|
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 217.333.0382 http://webservices.uiuc.edu |
