On 1-Sep-06, at 3:49 PM, Merlin Moncure wrote:
On 01 Sep 2006 19:00:52 +0200, Guillaume Cottenceau <gc@xxxxxx> wrote:
Hi,
I've been looking at the results from the pg_statio* tables, to
view the impact of increasing the shared buffers to increase
performance.
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.
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
