Francisco Reyes <lists(at)natserv(dot)com> writes:
> It seems a common issue for newbies, yet I don't see any docs on the
> subject. Maybe there are, I just don't know where they are.
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/performance-tips.html
There is a slightly improved (IMHO) writeup in the 7.2 docs,
http://candle.pha.pa.us/main/writings/pgsql/sgml/performance-tips.html
but this also talks about features like EXPLAIN ANALYZE that don't
exist in 7.1 ...
regards, tom lane