Re: indexes are farked

On Tue, 2005-08-02 at 13:05, Dr NoName wrote:
> siam_production=> explain analyze select * from render
> where person_id = 432;
>
> QUERY PLAN
> --------------------------------------------------------------------------------------------------------------
> Seq Scan on render (cost=0.00..39014.72 rows=27833
> width=1493) (actual time=7.11..743.55 rows=5261
> loops=1)
> Filter: (person_id = 432)
> Total runtime: 747.42 msec
> (3 rows)

Notice the disparity here? The query planner thinks that there's gonna
be 27833 rows returned, but there's only really 5261 being returned.

When's the last time you analyzed this table? And have you considered
running the pg_autovacuum daemon, which will vacuum and analyze for you
in the back ground?