Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Here is a narrowed down example.
In what locale/encoding? Can we see the pg_stats row for person_idx_3?
> PostgreSQL is version 8.1.9.
So it hasn't got the LIKE estimation fixes I put in two months ago ...
regards, tom lane
Am Freitag, 28. Dezember 2007 schrieb Tom Lane:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > I have been observing a case where the row count estimation for LIKE
> > 'foo' is (much) higher than for LIKE 'foo%', the rest of the query being
> > the same. This is a special case of the estimation
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I have been observing a case where the row count estimation for LIKE 'foo' is
> (much) higher than for LIKE 'foo%', the rest of the query being the same.
> This is a special case of the estimation for equality being higher than for a
> range query th
I have been observing a case where the row count estimation for LIKE 'foo' is
(much) higher than for LIKE 'foo%', the rest of the query being the same.
This is a special case of the estimation for equality being higher than for a
range query that includes the value used in the equality.
I have
