Re: annoying query/planner choice - Mailing list pgsql-performance

From Andrew Rawnsley
Subject Re: annoying query/planner choice
Date
Msg-id 83C6D7BA-44B4-11D8-8262-000393A47FCC@ravensfield.com
Whole thread Raw
In response to Re: annoying query/planner choice  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: annoying query/planner choice
Next
From: Christopher Browne
Date:
Subject: Re: annoying query/planner choice