How to configure on a machine with a lot of memory?
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.
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@gmail.com> wrote:Show quoted text
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