Re: [PERFORM] Query slow after VACUUM ANALYZE

2005-09-05 Thread Tom Lane
[EMAIL PROTECTED] writes: > Any ideas what I can do to make the query running in < 10 seconds? Increase work_mem (or sort_mem in older releases). PG is dropping back from the hash plan because it thinks the hashtable won't fit in work_mem. regards, tom lane -

Re: [PERFORM] Query slow after VACUUM ANALYZE

2005-09-05 Thread gdh
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