Hello All:
In the code (costsize.c), I see that effective_cache_size is set
to DEFAULT_EFFECTIVE_CACHE_SIZE.
This is defined as follows in cost.h
#define DEFAULT_EFFECTIVE_CACHE_SIZE 16384
But when I say
show shared_buffers in psql I get,
shared_buffers 28MB
In postgresql.conf
On 25/05/10 19:49, MMK wrote:
Hello All:
In the code (costsize.c), I see that effective_cache_size is set to
DEFAULT_EFFECTIVE_CACHE_SIZE.
This is defined as follows in cost.h
#define DEFAULT_EFFECTIVE_CACHE_SIZE 16384
But when I say
show shared_buffers in psql I get,
shared_buffers
Linnakangas heikki.linnakan...@enterprisedb.com
Subject: Re: [HACKERS] Confused about the buffer pool size
To: MMK bom...@yahoo.com
Cc: PostgreSQL-development pgsql-hackers@postgresql.org
Date: Tuesday, May 25, 2010, 11:36 AM
On 25/05/10 19:49, MMK wrote:
Hello All:
In the code (costsize.c), I see
MMK,
But it does not tell my anything about what the actual buffer size is.
How do I know what the real buffer size is? I am using 8.4.4 and I am
running only one query at a time.
Please move this discussion to the pgsql-general or pgsql-performance
lists. pgsql-hackers is for working on