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
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..0.00
[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