From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | "Guillaume Cottenceau" <gc(at)mnc(dot)ch>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: increasing shared buffers: how much should be removed from OS filesystem cache? |
Date: | 2006-09-01 23:22:51 |
Message-ID: | E3AD303F-06FE-4034-A176-3F532720A386@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 1-Sep-06, at 3:49 PM, Merlin Moncure wrote:
> On 01 Sep 2006 19:00:52 +0200, Guillaume Cottenceau <gc(at)mnc(dot)ch> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-09-02 00:24:18 | Re: increasing shared buffers: how much should be removed |
Previous Message | weisong44@gmail.com | 2006-09-01 21:56:20 | Hanging queries on Windows 2003 SP1 |