Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> writes: > production=*# explain analyse select * from boxes; > QUERY PLAN > --------------------------------------------------------------------------------------------------------------- > Seq Scan on boxes (cost=0.00..990783.99 rows=6499 width=581) (actual time=6.514..4588.136 rows=3060 loops=1) > Total runtime: 4588.729 ms > (2 rows) That cost estimate seems pretty dang large for a table with only 6500 rows. I suspect this table is horribly bloated, and the indexscan manages to win because it's not visiting pages that contain only dead rows. Try VACUUM FULL, and if that makes things saner, re-examine your autovacuum settings. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
