Re: How to configure on a machine with a lot of memory?

От:

Glyn Astill <glynastill@yahoo.co.uk>

Дата:

17 марта 2009 г. в 06:41:03

Start by looking here http://www.postgresql.org/docs/8.3/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY

And if you search the lists you'll find whole discussions on this topic that have been repeated over and over.

Without generalising too much, for a dedicated machine you should be looking at setting effective_cache_size to approx 2/3 of ram, shared_buffers to something like 10-15% of ram, and work_mem to something reasonable dependant on amount of connections and types of queries, but remember to keep this small-ish, mine is set at 2mb.

--- On Tue, 17/3/09, A B  wrote:

> From: A B 
> Subject: [GENERAL] How to configure on a machine with a lot of memory?
> To: pgsql-general@postgresql.org
> Date: Tuesday, 17 March, 2009, 9:20 AM
> Hi there!
> 
> If I have a database that have a size of a few GB and run
> this on a
> machine with 48 GB  of ram, What parameters should I set to
> make
> Postgres use all the memory that is available? For a not so
> very
> technical person it is a little cryptic to find out.
> 
> Thanks.
> 
> -- 
> Sent via pgsql-general mailing list
> (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

How to configure on a machine with a lot of memory?

От:

A B <gentosaker@gmail.com>

Дата:

17 марта 2009 г. в 06:21:00

Hi there!

If I have a database that have a size of a few GB and run this on a
machine with 48 GB  of ram, What parameters should I set to make
Postgres use all the memory that is available? For a not so very
technical person it is a little cryptic to find out.

Thanks.