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