I think 'shared buffers' is one of the most overrated settings from a
performance standpoint. however you must ensure there is enough for
things the server does besides caching. It used to be a bigger deal
than it is in modern versionf of postgresql modern operating systems.
Previous to 8.1 I would agree with you, but as of 8.1 it is probably the
most underrated.
Joshua D. Drake
merlin
So if shared buffers is the most overrated, what do you consider the
proper way of tuning ?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
