Re: [PERFORM] Query slow after VACUUM ANALYZE

Hi again [..] > >QUERY PLAN > - > Seq Scan on orders (cost=0.00..12184.14 rows=29526 width=33) >Filter: (NOT (hashed subplan)) >SubPlan > -> Seq Scan on orders_items (cost=0.00

[PERFORM] Query slow after VACUUM ANALYZE

Hi all I'm having a strange problem with a query which looks like this: SELECT id FROM orders WHERE id NOT IN (SELECT order_id FROM orders_items); The id fields are varchars (32), both indexed. The number of rows in the tables are about 6. Now, the really strange part is if I delete all dat