Re: [PERFORM] work-mem how do I identify the proper size

2007-01-29 Thread Bill Moran
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 from disk

[PERFORM] work-mem how do I identify the proper size

2007-01-28 Thread Campbell, Lance
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