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
