From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Randy Johnson *EXTERN*" <randy(dot)johnson(at)smokingpipes(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: config file question between versions 7.4 - 9.1 |
Date: | 2012-05-10 07:57:27 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C207DEC765@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Randy Johnson wrote:
> in the config file for 7.4 we have an entry:
>
> shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each
>
> in 9.1 the default is:
>
> shared_buffers = 32MB
>
>
> max connections is the default 100
>
> Do I need to make any adjustments or can I leave it at the default?
>
> The machine is dedicated to Postgres and has 8GB of memory and a
default install of 9.1 and 7.4
> doesn't appear to have any custom configuration.
Read the documentation at
http://www.postgresql.org/docs/current/static/runtime-config-resource.ht
ml#GUC-SHARED-BUFFERS
I'd set it to something between 500MB and 2GB.
You can use the pg_buffercache contrib module to check how
the buffer cache is used and adjust accordingly.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel McGreal | 2012-05-10 08:25:49 | Prepared statements performance |
Previous Message | Darren Duncan | 2012-05-10 05:45:58 | how best to see session data in triggers, or auditing methods |