Low (1000). I'll fiddle with that. I just noticed that the machine only has 512MB of ram in it, and not 1GB. I must
have raided it for some other machine...
On Jan 11, 2004, at 10:50 PM, Dennis Bjorklund wrote:
On Sun, 11 Jan 2004, Andrew Rawnsley wrote:--------------------
20-25% of the time. Fiddling with CPU_TUPLE_COST doesn't do anything
until I exceed 0.5, which strikes me as a bit high (though please
correct me if I am assuming too much...). RANDOM_PAGE_COST seems to have
no effect.
What about the effective cache size, is that set properly?
-- /Dennis Björklund
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend