>
> Possibly the table's never been ANALYZEd ... do you have autovacuum
> enabled? =C2=A0If it has been analyzed reasonably recently, then it might=
be
> necessary to crank up the statistics target to get a better estimate.
> It's difficult to give detailed advice when you haven't mentioned what
> PG version you're running.
>
I do have autovacuum enabled and I am running 8.4
autovacuum =3D on
vacuum_cost_limit =3D 150
log_autovacuum_min_duration =3D 0
autovacuum_max_workers =3D 4
autovacuum_naptime =3D 5min
autovacuum_vacuum_cost_delay =3D 30ms