Re: 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

From: Sergey Burladyan <eshkinkot(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )
Date: 2009-07-07 22:32:53
Message-ID: 87iqi4ktt6.fsf@seb.progtech.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Oh, now problem with simple query:

8.4.0 from Debian
explain analyze select i from t where i >= 10 and i = 1;
QUERY PLAN
------------------------------------------------------------------------------------
Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)
One-Time Filter: false
Total runtime: 0.030 ms

CVS HEAD
explain analyze select i from t where i >= 10 and i = 1;
QUERY PLAN
---------------------------------------------------------------------------------------------------
Seq Scan on t (cost=0.00..17030.00 rows=1 width=4) (actual time=449.651..449.651 rows=0 loops=1)
Filter: ((i >= 10) AND (i = 1))
Total runtime: 449.726 ms

--
Sergey Burladyan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-07-07 22:33:19 Re: *_collapse_limit, geqo_threshold
Previous Message Robert Haas 2009-07-07 22:29:10 Re: *_collapse_limit, geqo_threshold