On Fri, Feb 04, 2011 at 03:46:35PM +0100, felix wrote: > directly after REINDEX and ANALYZE: > > Aggregate (cost=62348.70..62348.71 rows=1 width=0) (actual > time=15830.000..15830.000 rows=1 loops=1) > -> Seq Scan on fastadder_fastadderstatus (cost=0.00..61613.16 > rows=294216 width=0) (actual time=30.000..15570.000 rows=302479 loops=1) > Total runtime: 15830.000 ms
do run vacuum of the table. reindex doesn't matter for seq scans, and analyze, while can help choose different plan - will not help here anyway. Best regards, depesz -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
