[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [HACKERS] limit in subquery causes poor selectivity estimation
From: Tom Lane <tgl () sss ! pgh ! pa ! us>
Date: 2011-08-31 18:12:58
Message-ID: 21748.1314814378 () sss ! pgh ! pa ! us
[Download RAW message or body]
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Aug 31, 2011 at 6:22 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
>> I liked the old one better. ;-)
> AFAICS, those plans are identical, except for a minor difference in
> the cost of scanning test2.
The point is that the estimate of the result size is worse in 8.4.8.
I am not, however, convinced that 8.4.7 was actually smarter ... it
may have been getting the right answer for the wrong reason.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic