Re: Optimizer improvements: to do or not to do? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Optimizer improvements: to do or not to do?
Date
Msg-id 15790.1158070606@sss.pgh.pa.us
Whole thread Raw
In response to Re: Optimizer improvements: to do or not to do?  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> It's possible there's some sort of "block-wise correlated" measure
> which would be even better for our needs.

Actually, it seems obvious to me that the correlation measure ought to
ignore within-block ordering, but right now it does not.  OTOH it's not
clear how important that is, as on a decent-size table you'll probably
not have more than one sample row in a block anyway.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Optimizer improvements: to do or not to do?
Next
From: Naz Gassiep
Date:
Subject: Re: dump / restore functionality