Start by taking a gander at: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html and http://www.powerpostgresql.com/Downloads/annotated_conf_80.html Why are you using 7.4.8 instead of the current version of PostgreSQL?
Probably because it is what shipping which his copy of Linux :) Joshua D. Drake
Cheers, Steve ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org