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

From Alberto Dalmaso
Subject Re: Speeding up a query.
Date
Msg-id 1245231239.5027.113.camel@dalmaso-opensuse.cl
Whole thread Raw
In response to Speeding up a query.  ("Hartman, Matthew" <Matthew.Hartman@krcc.on.ca>)
Responses Re: Speeding up a query.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Speeding up a query.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
yes, I have to make that because the data on the table need to be
pivoted so it is joined many times with different filter on the column
that describe the meaning of the column called numeric_value I'm going
to show.
That could be very ineffective, event because that table contains
something like 25000000 rows...
There are two tables in this condition (as you can se in the explain)
and both are the table with the higher number of rows in the database.
But I don's see any other choice to obtain that information.

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)...


pgsql-performance by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Speeding up a query.
Next
From: Heikki Linnakangas
Date:
Subject: Re: GiST index performance