Re: Speeding up a query.

Alberto Dalmaso <dalmaso@clesius.it> writes:
> P.S.: i'm trying with all enable_* to on and pumping to higher values
> from_collapse_limit and join_collapse_limit that I've put to 30.
> The result is that the query, after an hour of work, goes out of memory
> (SQL State 53200)...

Hmm, is that happening during planning (ie, do you get the same error
if you just try to EXPLAIN the query with those settings)?  If not,
please show the EXPLAIN output.

            regards, tom lane