Re: performance with query

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

P.S.: to understand what the query has to make (and 80% of the view hve
these to make): a lot of time is spend to pivoting a table with a
structure like
identifier, description_of_value, numeric value
that has to be transformed in
identifier, description_1, description_2, ..., description_n
where n is not a fixed number (it changes in function of the type of
calculation that was used to generate the rows in the table).

perhaps this information could help.

thanks everybady

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2009-06-18 15:19:33 Re: enum for performance?
Previous Message Tom Lane 2009-06-18 00:17:35 Re: very slow selects on a small table