5 ms·
If high-performance PostgreSQL is critical to your job, here are some resources: http://wiki.postgresql.org/wiki/Slow_Query_Questions http://wiki.postgresql.or
by jpitz 14y ago
If high-performance PostgreSQL is critical to your job, here are some resources:
http://wiki.postgresql.org/wiki/Slow_Query_Questions http://wiki.postgresql.org/wiki/Slow_Query_Questions
Query analysis tool http://explain.depesz.com http://explain.depesz.com
The mailing list http://www.postgresql.org/list/pgsql-performance/ http://www.postgresql.org/list/pgsql-performance/
Greg Smith's book http://www.amazon.com/PostgreSQL-High-Performance-Gregory-Smith/dp/184951030X http://www.amazon.com/PostgreSQL-High-Performance-Gregory-Sm...
#postgresql on freenode.net
- No1 14y agoSome good resources there. Don't forget to mention PgAdmin III has a built-in graphical explain analyze, which is absolutely amazing yet rarely talked about. http://www.postgresonline.com/journal/archives/27-Reading-PgAdmin-Graphical-Explain-Plans.html http://www.postgresonline.com/journal/archives/27-Reading-Pg...