Re: [PERFORM] Quad processor options

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Paul Tuckfield <paul(at)tuckfield(dot)com>
Cc: Bjoern Metzdorf <bm(at)turtle-entertainment(dot)de>, "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Quad processor options
Date: 2004-05-12 10:17:27
Message-ID: 5nt3a05l0q1ivc2179qsjqhpa141stu9ek@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

On Tue, 11 May 2004 15:46:25 -0700, Paul Tuckfield <paul(at)tuckfield(dot)com>
wrote:
>- the "cache" column shows that linux is using 2.3G for cache. (way too
>much)

There is no such thing as "way too much cache".

> you generally want to give memory to postgres to keep it "close" to
>the user,

Yes, but only a moderate amount of memory.

> not leave it unused to be claimed by linux cache

Cache is not unused memory.

>- I'll bet you have a low value for shared buffers, like 10000. On
>your 3G system
> you should ramp up the value to at least 1G (125000 8k buffers)

In most cases this is almost the worst thing you can do. The only thing
even worse would be setting it to 1.5 G.

Postgres is just happy with a moderate shared_buffers setting. We
usually recommend something like 10000. You could try 20000, but don't
increase it beyond that without strong evidence that it helps in your
particular case.

This has been discussed several times here, on -hackers and on -general.
Search the archives for more information.

Servus
Manfred

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Halford Dace 2004-05-12 10:27:18 Re: [PERFORM] Quad processor options
Previous Message Christian Kratzer 2004-05-12 10:13:24 Re: [SQL] \set

Browse pgsql-performance by date

  From Date Subject
Next Message Halford Dace 2004-05-12 10:27:18 Re: [PERFORM] Quad processor options
Previous Message Shridhar Daithankar 2004-05-12 09:02:54 Re: Clarification on some settings