On Jun 28, 2008, at 12:53 AM, Bob Duffey wrote:
> If you're iterating through the records with a cursor, the plan may
> be different, IIRC - weighted to provide first row quickly, as opposed
> to the query that was run that's weighted to provide last row quickly.
> I agree, and I was hoping that would be the case, but as it happens
> it wasn't. Anyway, reducing random_page_cost seems to have resulted
> in the "right" plan being selected.
The original query you mentioned was not using a cursor, though, it
was just a select.
Did you try it using a cursor?
In response to
pgsql-general by date
|Next:||From: David Rowley||Date: 2008-06-28 23:22:44|
|Subject: Re: dblink to non postgresql dbms|
|Previous:||From: Tom Lane||Date: 2008-06-28 15:08:29|
|Subject: Re: query planner weirdness? |