Re: Row count estimation bug in BETWEEN?

From: Yaroslav <ladayaroslav(at)yandex(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Row count estimation bug in BETWEEN?
Date: 2015-06-14 10:59:02
Message-ID: 1434279542873-5853771.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> My simple test (using MCVs) is below ...
I've posted wrong second query in the test, should have been:
EXPLAIN SELECT * FROM t2 WHERE n >= 0 AND n <= 2
-- rows=12

-----
WBR, Yaroslav Schekin.
--
View this message in context: http://postgresql.nabble.com/Row-count-estimation-bug-in-BETWEEN-tp5853687p5853771.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-06-14 16:09:05 Re: Row count estimation bug in BETWEEN?
Previous Message Yaroslav 2015-06-13 20:51:50 Re: Row count estimation bug in BETWEEN?