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 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,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu