Hi,
there are many Hash and Merge joins that may generate a lot of temp space,
it could also be a problem of forgotten column in the join.
Could you also provide indexes definitions (pk, uk and others)
with the EXPLAIN (ANALYZE BUFFERS)
(you can limit the scope of the query to help it to finish by limiting the
number of lines from candidates by
...
*FROM match_candidate_address WHERE account_id NOT IN (:exclude_ids)
limit 100
*
)
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html