From: gokulnathbabu manoharan <gokulnathbabu@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Caching by Postgres
Date: Tue, 23 Aug 2005 10:10:45 -0700 (PDT)
Message-ID: <20050823171045.12112.qmail@web51309.mail.yahoo.com> (raw)
Hi all,
I like to know the caching policies of Postgresql.
What parameter in the postgresql.conf affects the
cache size used by the Postgresql? As far as I have
searched my knowledge of the parameters are
1. shared_buffers - Sets the limit on the amount of
shared memory used. If I take this is as the cache
size then my performance should increase with the
increase in the size of shared_buffers. But it seems
it is not the case and my performance actually
decreases with the increase in the shared_buffers. I
have a RAM size of 32 GB. The table which I use more
frequently has around 68 million rows. Can I cache
this entire table in RAM?
2. work_mem - It is the amount of memory used by an
operation. My guess is once the operation is complete
this is freed and hence has nothing to do with the
caching.
3. effective_cache_size - The parameter used by the
query planner and has nothing to do with the actual
caching.
So kindly help me in pointing me to the correct
parameter to set.
It will be great if you can point me to the docs that
explains the implementation of caching in Postgresql
which will help me in understanding things much
clearly.
Thanks in advance.
Gokul.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gokulnathbabu@yahoo.com
Subject: Re: Caching by Postgres
In-Reply-To: <20050823171045.12112.qmail@web51309.mail.yahoo.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