Re: Optimizer improvements: to do or not to do?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Say42 <andrews42(at)yandex(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Optimizer improvements: to do or not to do?
Date: 2006-09-12 14:16:46
Message-ID: 15790.1158070606@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregory Stark <stark(at)enterprisedb(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-09-12 14:16:50 Re: Optimizer improvements: to do or not to do?
Previous Message Peter Eisentraut 2006-09-12 14:14:14 Re: dump / restore functionality