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
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114

---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to