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

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 <gentosaker(at)gmail(dot)com> wrote:

> From: A B <gentosaker(at)gmail(dot)com>
> Subject: [GENERAL] How to configure on a machine with a lot of memory?
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general