Re: Query w empty result set with LIMIT orders of magnitude slower than without

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Frank Joerdens" <frank(at)joerdens(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org, Nic <nferrier(at)tapsellferrier(dot)co(dot)uk>, "Seb Potter" <seb(at)woome(dot)com>
Subject: Re: Query w empty result set with LIMIT orders of magnitude slower than without
Date: 2008-08-26 16:53:09
Message-ID: 10025.1219769589@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Frank Joerdens" <frank(at)joerdens(dot)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:

> -> Index Scan Backward using webapp_invite_pkey on
> webapp_invite (cost=0.00..201698.51 rows=382 width=44) (actual
> time=2545.131..2545.131 rows=0 loops=1)
> Filter: ((woouser)::text = 'suggus'::text)

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Frank Joerdens 2008-08-26 16:59:49 Re: Query w empty result set with LIMIT orders of magnitude slower than without (SOLVED, pls disregard)
Previous Message Jerry Champlin 2008-08-26 16:45:31 Re: Autovacuum does not stay turned off