From: Kailash Vyas <kailash.vyas@gmail.com>
To: pgsql-admin@postgresql.org
Subject: postgres optimization
Date: Fri, 29 Jul 2005 12:34:12 +0100
Message-ID: <a3cc791705072904344eeeb058@mail.gmail.com> (raw)
hi
I need some information to optimize the postgres database server (7.3.10).
I have 2 Gb RAM on the server.
I have set the /proc/sys/kernel/shmmax and /proc/sys/kernel/shmall to
536870912 (512 Mb)
should i set the shmmax and shmall to use 2 GB or it is better to keep it
less.
also how does it affect the performance and stability of system
what would be the ideal shared buffer size and effective cache size to be
set in conf file.
currently i am using this expression to find out shared buffers parameter
max connections = 128
250kB + 8.2 kB * shared_buffers + 14.2 kB * max_connections or infinity
shared buffers = 65277 (approx)
also regarding the effective cache size how much should i set that to ?
one of the article suggested this so which option would be more optimized
"there is 1.5GB RAM in your machine, shared buffers are set to 32MB and
effective cache size is set to 800MB. So if a query needs 700MB of data set,
PostgreSQL would estimate that all the data required should be available in
memory and would opt for more aggressive plan in terms of optimization,
involving heavier index usage and merge joins. But if effective cache is set
to only 200MB, the query planner is liable to opt for the more I/O efficient
sequential scan."
thanks,
kailash
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: kailash.vyas@gmail.com
Subject: Re: postgres optimization
In-Reply-To: <a3cc791705072904344eeeb058@mail.gmail.com>
References: <a3cc791705072904344eeeb058@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox