On Thu, Mar 20, 2014 at 8:51 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Atri Sharma <atri.j...@gmail.com> writes: > > Now, why cannot we take the estimate of all the buckets behind the bucket > > in which our value is present? Will that estimate not give us the > fraction > > of tuples that are expected to be before the first matching row? > > Uh, no, not unless you assume that the table happens to be perfectly > sorted by the column's value. > > > Yes, that is true. So, if an attribute has an index present, can we do this somehow? Regards, Atri -- Regards, Atri *l'apprenant*
