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 <gentosa...@gmail.com> wrote: > From: A B <gentosa...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
