[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: [PERFORM] Query w empty result set with LIMIT orders of magnitude slower than without
From: "Frank Joerdens" <frank () joerdens ! de>
Date: 2008-08-26 18:41:49
Message-ID: 7d10d2df0808261141k4ca6800dm5c847098af8da51d () mail ! gmail ! com
[Download RAW message or body]
On Tue, Aug 26, 2008 at 5:53 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Frank Joerdens" <frank@joerdens.de> writes:
>> It seems to me that the planner makes a very poor decision with this
>> particular query:
>
> Try increasing the stats on woouser. You need it to make a smaller
> estimate of the number of matching rows here:
Way cool, this
alter table webapp_invite alter column woouser set statistics 50;
did the trick, without cleaning up the spurious join there even.
Thanks!
Frank
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic