Re: Confirmation of bad query plan generated by 7.4 tree

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Shaun Thomas" <sthomas(at)leapfrogonline(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Confirmation of bad query plan generated by 7.4 tree
Date: 2006-06-13 18:09:28
Message-ID: 9119.1150222168@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Shaun Thomas" <sthomas(at)leapfrogonline(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marcin Mank 2006-06-13 18:17:46 Re: Confirmation of bad query plan generated by 7.4 tree
Previous Message Steve Poe 2006-06-13 18:02:40 Which processor runs better for Postgresql?