Re: annoying query/planner choice

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Andrew Rawnsley <ronz(at)ravensfield(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: annoying query/planner choice
Date: 2004-01-12 03:50:25
Message-ID: Pine.LNX.4.44.0401120449300.13405-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2004-01-12 03:56:59 Re: annoying query/planner choice
Previous Message Andrew Rawnsley 2004-01-12 03:05:11 annoying query/planner choice