[HACKERS] Confused about the buffer pool size

2010-05-25 Thread MMK
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

Re: [HACKERS] Confused about the buffer pool size

2010-05-25 Thread Heikki Linnakangas
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

Re: [HACKERS] Confused about the buffer pool size

2010-05-25 Thread MMK
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

Re: [HACKERS] Confused about the buffer pool size

2010-05-25 Thread Josh Berkus
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