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

From Dennis Bjorklund
Subject Re: annoying query/planner choice
Date
Msg-id Pine.LNX.4.44.0401120449300.13405-100000@zigo.dhs.org
Whole thread Raw
In response to annoying query/planner choice  (Andrew Rawnsley <ronz@ravensfield.com>)
Responses Re: annoying query/planner choice  (Andrew Rawnsley <ronz@ravensfield.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Andrew Rawnsley
Date:
Subject: annoying query/planner choice
Next
From: Andrew Rawnsley
Date:
Subject: Re: annoying query/planner choice