On Thu, 20 Jun 2002, Gregory Wood wrote:
> Trying to use a single column index on a somewhat large table (1.9M rows),
> and PostgreSQL really doesn't want to. It estimates the number of rows at
> 12749 (actual 354), which is only .6% of the table... well within reasonable
> index range I would think. And yes, I've run an analyze on the table.
It might be interesting to figure out why it's over estimating the rows
so badly. What do the statistics in pg_statistic for that
relation/attribute look like?