Skip site navigation (1) Skip section navigation (2)

Re: query planner weirdness?

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: query planner weirdness?
Date: 2008-06-28 16:39:14
Message-ID: 93BE1FE6-8054-455F-81BD-B843507EF6B1@blighty.com (view raw or flat)
Thread:
Lists: pgsql-general
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?

Cheers,
   Steve


In response to

pgsql-general by date

Next:From: David RowleyDate: 2008-06-28 23:22:44
Subject: Re: dblink to non postgresql dbms
Previous:From: Tom LaneDate: 2008-06-28 15:08:29
Subject: Re: query planner weirdness?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group