If I set work-mem at a particular amount of memory how do I answer the
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 a query had to go to disk in order to be sorted or completed
is there a way to identify how much memory it would have taken in order
to run the query from memory?
Thanks for all of your help,
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
pgsql-performance by date
|Next:||From: Arnau||Date: 2007-01-29 12:21:56|
|Subject: [OT] Very strange postgresql behaviour|
|Previous:||From: Tom Lane||Date: 2007-01-28 23:38:18|
|Subject: Re: Tuning |