| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2008-06-28 23:22:44 | Re: dblink to non postgresql dbms |
| Previous Message | Tom Lane | 2008-06-28 15:08:29 | Re: query planner weirdness? |