If high-performance PostgreSQL is critical to your job, here are some resources:... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

jpitz on Jan 17, 2013 | parent | context | favorite | on: Handling Growth with Postgres

If high-performance PostgreSQL is critical to your job, here are some resources:

http://wiki.postgresql.org/wiki/Slow_Query_Questions

Query analysis tool http://explain.depesz.com

The mailing list http://www.postgresql.org/list/pgsql-performance/

Greg Smith's book http://www.amazon.com/PostgreSQL-High-Performance-Gregory-Sm...

#postgresql on freenode.net

No1 on Jan 18, 2013 [–]

Some 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-Pg...

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact