BullElephant
@Postgrestips
Database, Postgresql, Postgres, PL/PgSQL, SQL, Databases, tips, tricks
Looking to test performance on your Postgres DB? Try PGBench or Hammerora.
Looking for agreat Open Source solution to your #Postgres backup/recovery needs? Try Barman bit.ly/REpGjK
A function-based-index is an index using functions in the definition: You can index UPPER(NAME) instead of just NAME. is.gd/4ilAKZ
Explore possibilities without having to break the bank. #PostgreSQL has many tools available for free #opensource. bit.ly/U96x8M
We're thrilled to see #PostgreSQL made @NetworkWorld's top 10 most successful open source projects of 2012! ow.ly/gcVAn
Maintain your index-only scans. Otherwise, adding a new filter to the WHERE clause can make the query slower! is.gd/J58biR
If you are looking for a tutorial on Postgres: bit.ly/U7oYf5
Stop worrying about database performance and learn to use the index. use-the-index-luke.com
Andrew Dunstan: When you upgrade to PostgreSQL 9.2, run vacuum right away. postgr.es/p/1Gm
Hubert 'depesz' Lubaczewski: Waiting for 9.3 – Support automatically-updatable views. postgr.es/p/1Gk
Wanna see how your database is doing? SELECT * FROM pg_stat_database WHERE datname = 'yourdbname'
Using JSON? Need something that will integrate with your application architecture smoothly? #JSON #Postgres bit.ly/TNMKct
If you come to Postgres from another database and start looking for licensing limits, you are going to be really disappointed.
Jim Smith: Why Federal Agencies are Turning to PostgreSQL postgr.es/p/1Gl
Since Postgres is open source, no one really minds if you tweak the code. Here is a map to help you do so: bit.ly/UbcAa5
United States Тренды
- 1. $NVDA 78.6K posts
- 2. Jensen 25.2K posts
- 3. Peggy 38.8K posts
- 4. GeForce Season 5,933 posts
- 5. NASA 55.2K posts
- 6. #ใครในกระจกEP5 9,436 posts
- 7. #YIAYalpha N/A
- 8. Sumrall 2,489 posts
- 9. Arabic Numerals 4,712 posts
- 10. Stargate 7,292 posts
- 11. #WickedWaysToMakeABuck N/A
- 12. Martha 20.3K posts
- 13. Kwame 6,631 posts
- 14. Comey 58.9K posts
- 15. Saba 11K posts
- 16. #WWESuperCardNewSeason 1,189 posts
- 17. Sam Harris N/A
- 18. #2Kgiveaway 1,185 posts
- 19. Poverty 54.9K posts
- 20. Judge Smith 3,292 posts
Something went wrong.
Something went wrong.