Re: annoying query/planner choice

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
> majordomo@postgresql.org
>
--------------------

Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com