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/3of ram, shared_buffers to something like 10-15% of ram, and work_mem to something reasonable dependant on amount of
connectionsand types of queries, but remember to keep this small-ish, mine is set at 2mb.
--- On Tue, 17/3/09, A B <gentosaker@gmail.com> wrote:
> From: A B <gentosaker@gmail.com>
> 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
