Bunları beğenebilirsin
Postgres TOTD: Use the 'END' as a shortcut for context-sensitive COMMIT or ROLLBACK.
Postgres TOTD: VACUUM FULL and REINDEX do heavy locking, but with autovacuum you should rarely need them.
Postgres TOTD: Logging can go through syslog: control the facility and ident via postgresql.conf.
Postgres TOTD: Postgres 8.4 has a backwards-compatible psql, including backslash commands (finally!)
Postgres TOTD: A table can be physically reordered based on an index with the CLUSTER command. http://tr.im/sI5d
Postgres TOTD: 8.4 has windowing functions: see how they compare to other dbs: http://tr.im/snRO
Postgres TOTD: ANALYZE can be run on the entire database, on a single table, and even on a single column. http://tr.im/sc1L
Postgres TOTD: View PostgreSQL information in a format similar to the Unix tool 'top' with pg_top: http://tr.im/pNXr
Postgres TOTD: Postgres 8.4 gets rid of max_fsm_pages and max_fsm_relations. Two less knobs to worry about!
Postgres TOTD: Postgres natively supports many DTrace probes as of version 8.2. http://tr.im/pvPk
Postgres TOTD: Don't kill -9 backends. Postgres will survive, but other clients may have to reconnect.
Postgres TOTD: LEFT and RIGHT joins are equivalent, so always use LEFT joins to reduce confusion. http://tr.im/oS3I
Postgres TOTD: Subqueries can be used almost everywhere: select (select 1) as c from (select 1) t where 1 = (select 1) limit (select 1);
Postgres TOTD: Make sure you run a global ANALYZE after restoring a database or any other large data import.
Postgres TOTD: When working on someone else's system, call psql with -X to bypass any unknown conf files.
Postgres TOTD: In psql, see how fast all your queries take by toggling \timing on.
Postgres TOTD: Temporary tables can be set as ON COMMIT DELETE to automatically remove them. http://tr.im/nXRC
Postgres TOTD: Starting in PostgreSQL version 8.4, you can use ON TRUNCATE triggers. http://tr.im/nQ7I
Postgres TOTD: One of the many languages available for PostgreSQL functions is LOLCODE. http://tr.im/nAjS (YA RLY!)
Postgres TOTD: When writing functions, put the LANGUAGE declaration with the rest of the metadata at the top.
United States Trendler
- 1. Rashford 20.4K posts
- 2. Fermin 43.4K posts
- 3. White House 452K posts
- 4. ChatGPT Atlas 5,381 posts
- 5. #pilotstwtselfieday 1,215 posts
- 6. Crosby 5,002 posts
- 7. Olympiacos 35.9K posts
- 8. Woody Johnson 1,328 posts
- 9. Kurt Suzuki 2,063 posts
- 10. Lakers 32.2K posts
- 11. Lamine 24.2K posts
- 12. Barca 61.4K posts
- 13. NASA 63.4K posts
- 14. John Brennan 11.5K posts
- 15. #ScarierThanHalloween N/A
- 16. #TrumpHatesOurHealthCare 4,096 posts
- 17. #JUNGKOOKXCALVINKLEIN 59.7K posts
- 18. Barcelona 140K posts
- 19. Rick Scott 2,268 posts
- 20. Chrome 13.7K posts
Something went wrong.
Something went wrong.