Postgres Pro
Downloads
Home   >   mailing lists

Re: Confirmation of bad query plan generated by 7.4 tree - Mailing list pgsql-performance

From Tom Lane
Subject Re: Confirmation of bad query plan generated by 7.4 tree
Date
Msg-id 9119.1150222168@sss.pgh.pa.us
Whole thread Raw
In response to Confirmation of bad query plan generated by 7.4 tree  ("Shaun Thomas" <sthomas@leapfrogonline.com>)
Responses Re: Confirmation of bad query plan generated by 7.4  ("Shaun Thomas" <sthomas@leapfrogonline.com>)
List pgsql-performance
Tree view 
"Shaun Thomas" <sthomas@leapfrogonline.com> writes:
> Am I correct in assuming this terrible plan is due to our ancient
> version of Postgres?

I missed the part where you explain why you think this plan is terrible?
412ms for what seems a rather expensive query doesn't sound so awful.
Do you know an alternative that is better?

            regards, tom lane

pgsql-performance by date:

Previous
From: Steve Poe
Date:
Subject: Which processor runs better for Postgresql?
Next
From: "Marcin Mank"
Date:
Subject: Re: Confirmation of bad query plan generated by 7.4 tree