Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
> ... I don't know much about it, but I'll guess that you are
> exhausting memory just trying to *plan* the query, or that the
> bazillion intermediate results from the huge number of "or" clauses is
> chewing things up.
SET KSQO = 'ON' might help. I've reduced cnfify's tendence to eat
memory when presented with a big OR-of-ANDs clause, but that fix isn't
in 6.5.* (it still needs more work).
regards, tom lane