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
> > 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