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
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, C
