Thread: Best PostgreSQL Tuning Reference
What is the best reference out there for tuning PostgreSQL? Looking for a Web site or a book that has some info. Specifically, figuring out where bottlenecks are in a production system and the best way to tweak parameters, indices, queries... Obviously it will not be specific to my applications but I'm sure I could learn something. Thanks, Hunter
On Fri, 2003-02-21 at 13:51, Hunter Hillegas wrote: > What is the best reference out there for tuning PostgreSQL? Looking for a > Web site or a book that has some info. Query, Index, Database Tuning: http://www.postgresql.org/docs/aw_pgsql_book/node106.html http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/performance-tips.html http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/indexes-examine.html http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/admin.html Tuning for your Hardware: http://www.ca.postgresql.org/docs/momjian/hw_performance/ > Specifically, figuring out where bottlenecks are in a production system and > the best way to tweak parameters, indices, queries... Obviously it will not > be specific to my applications but I'm sure I could learn something. Past the official online documentation and the online books listed on the main site there are some other good resources. * newgroup archives * google :) * techdocs.postgresql.org