Re: performance with query

From: Alberto Dalmaso <dalmaso(at)clesius(dot)it>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org
Subject: Re: performance with query
Date: 2009-06-16 16:12:58
Message-ID: 1245168778.5027.82.camel@dalmaso-opensuse.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Unfortunatly the query need that level of complxity as the information I
have to show are spread around different table.
I have tryed the geqo on at the beginning but only with the default
parameters.
Tomorrow (my working day here in Italy is finished some minutes ago, so
I will wait for the end of the explain analyze and the go home ;-P )
I'll try to increase, as you suggest, join_collapse_limit and
from_collapse_limit.
If someone can give me some information on how to configure geqo, I'll
try it again.
In the meantime this night I leave the vacuum verbose to work for me.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alberto Dalmaso 2009-06-16 16:37:44 Re: performance with query
Previous Message Tom Lane 2009-06-16 16:12:56 Re: performance with query