Re: Speeding up a query. - Mailing list pgsql-performance

From Tom Lane
Subject Re: Speeding up a query.
Date
Msg-id 26803.1245251238@sss.pgh.pa.us
Whole thread Raw
In response to Re: Speeding up a query.  (Alberto Dalmaso <dalmaso@clesius.it>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Hartman, Matthew"
Date:
Subject: Re: Speeding up a query.
Next
From: Alberto Dalmaso
Date:
Subject: Re: performance with query