Hi,
On 03/22/2016 06:53 AM, Jeff Janes wrote:
On Sun, Mar 20, 2016 at 4:34 PM, Tomas Vondra
<tomas.von...@2ndquadrant.com> wrote:
D'oh. Thanks for reporting. Attached is v16, hopefully fixing the few
remaining whitespace issues.
Hi Tomas,
I'm trying out v16 against a common problem, where postgresql thinks
it is likely top stop early during a "order by (index express) limit
1" but it doesn't actually stop early due to cross-column
correlations. But the multivariate statistics don't seem to help. Am
I doing this wrong, or just expecting too much?
Yes, I think you're expecting a too much from the current patch.
I've been thinking about perhaps addressing cases like this in the
future, but it requires tracking position within the table somehow (e.g.
by means of including ctid in the table, or something like that), and
the current patch does not implement that.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
