In response to Campbell, Lance [EMAIL PROTECTED]:
If I set work-mem at a particular amount of memory how do I answer the
following questions:
1) How many of my queries were able to run inside the memory I
allocated for work-mem?
2) How many of my queries had to run from disk
I have been researching how to improve my overall performance of
postgres. I am a little confused on the reasoning for how work-mem is
used in the postgresql.conf file. The way I understand the
documentation is you define with work-mem how much memory you want to
allocate per search. Couldn't
work-mem tells the size of physical memory only, virtual memory is
always there off course in case you run out of available memory.
I recommend you reading PostgreSQL internals for all this stuff:
http://www.postgresql.org/docs/8.0/static/internals.html
--Imad
www.EnterpriseDB.com
On 1/29/07,
If I set work-mem at a particular amount of memory how do I answer the
following questions:
1) How many of my queries were able to run inside the memory I
allocated for work-mem?
2) How many of my queries had to run from disk because work-mem
was not set high enough?
3) If