[BUGS] full-text search doesn't fall back on sequential scan when it could

Y PLAN - Aggregate (cost=114.03..114.04 rows=1 width=0) (actual time=91.171..91.171 rows=1 loops=1) -> Seq Scan on two (cost=0.00..114.02 rows=5 width=0) (actual time=0.028..89.598 rows=3277

[BUGS] Optimization disaster

> Seq Scan on bc_catalog_x_elem (cost=0.00..520.03 rows=455 width=4) in (1) seems to be wrong... I do a VACUUM ANALYZE regularly. What's wrong? I don't want to turn off SEQ_SCAN, because many other queries will suffer. Dietrich ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html