PostgreSQL 8 performance tuning

Here’s my list of pointers:

  • Power PostgreSQL – really detailed and up-to-date information on setting PostgreSQL runtime parameters. Don’t forget to check the annotated postgresql.conf with comments. BTW: Looking forward to reading the forthcoming book.
  • Collection of PostgreSQL performance tips – a shopping lists of tips (both configuration as well as application design). The posts is a bit old, but many things (ecpesially the more general ones are still very relevant).
  • Performance Tuning PostgreSQL – a decent link, explaining both runtime settings (some of this might be obsolete) and the general concepts: EXPLAIN, ANALYZE, indices.
  • Postgres 8.x docs – explains runtime parameters in some detail.

One Response to “PostgreSQL 8 performance tuning”

  1. Xan Says:

    Thx. There is very helpfull references!!!

Leave a Reply