"Merlin Moncure" <[EMAIL PROTECTED]> writes: > Try bumping up shared buffers some and sort mem as much as you safely > can.
sort_mem is probably the issue here. The only reasonable way to do NOT IN is with a hash table, and the default setting of sort_mem is probably too small to support a 137042-element table. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend