BullElephant
@Postgrestips
Followers
7
Following
0
Media
0
Statuses
31
Database, Postgresql, Postgres, PL/PgSQL, SQL, Databases, tips, tricks
Joined December 2012
Josh Berkus: PostgreSQL 9.3: Current Feature Status http://t.co/BL7eFT4U
0
9
1
Looking to test performance on your Postgres DB? Try PGBench or Hammerora.
0
0
0
Looking for agreat Open Source solution to your #Postgres backup/recovery needs? Try Barman http://t.co/4pthgZC0
pgbarman.org
Allows your company to implement disaster recovery solutions for PostgreSQL databases with high requirements of business continuity.Taking an online hot backup of PostgreSQL is now as easy as...
0
0
0
Bruce Momjian: The NOT IN NULL Trap (Part 5/11) http://t.co/R8o1e3ds
0
2
3
A function-based-index is an index using functions in the definition: You can index UPPER(NAME) instead of just NAME. http://t.co/Vca4TkIg
0
4
4
Explore possibilities without having to break the bank. #PostgreSQL has many tools available for free #opensource. http://t.co/610fuDEK
0
0
0
We're thrilled to see #PostgreSQL made @NetworkWorld's top 10 most successful open source projects of 2012! http://t.co/CAno1KFD
0
6
0
Bruce Momjian: Postgres: The B-52 of Databases http://t.co/01N5E3Bp
0
4
2
Maintain your index-only scans. Otherwise, adding a new filter to the WHERE clause can make the query slower! http://t.co/a3IFOBod
0
5
4
If you are looking for a tutorial on Postgres: http://t.co/FE4M95N5
0
0
0
Stop worrying about database performance and learn to use the index. http://t.co/lR90icJl
1
10
11
Andrew Dunstan: When you upgrade to PostgreSQL 9.2, run vacuum right away. http://t.co/SRgqSDEy
0
4
2
Hubert 'depesz' Lubaczewski: Waiting for 9.3 – Support automatically-updatable views. http://t.co/Iy50KitC
0
3
1
Wanna see how your database is doing? SELECT * FROM pg_stat_database WHERE datname = 'yourdbname'
0
0
0
Using JSON? Need something that will integrate with your application architecture smoothly? #JSON #Postgres
http://t.co/uvFKmKVn
0
0
0
If you come to Postgres from another database and start looking for licensing limits, you are going to be really disappointed.
0
0
0
Jim Smith: Why Federal Agencies are Turning to PostgreSQL http://t.co/BpgDp41s
0
7
2
Since Postgres is open source, no one really minds if you tweak the code. Here is a map to help you do so: http://t.co/i6llE7GI
0
0
0