Re: [PERFORM] The black art of postgresql.conf tweaking

2004-08-09 Thread Paul Serby
eID_key" on "tblForumMessages" ~ (cost=0.00..8037.33 rows=2150 width=223) (actual time=0.153..0.153 rows=0 loops=1) ~ Index Cond: ("fk_iParentMessageID" = 90) ~ Total runtime: 0.323 ms SELECT COUNT(*) FROM "tblForumMessages" WHERE "fk_iParentMessageID"

[PERFORM] The black art of postgresql.conf tweaking

2004-08-04 Thread Paul Serby
Can anyone give a good reference site/book for getting the most out of your postgres server. All I can find is contradicting theories on how to work out your settings. This is what I followed to setup our db server that serves our web applications. http://www.phpbuilder.com/columns/smith2001082