Re: performance with query - Mailing list pgsql-performance

From Alberto Dalmaso
Subject Re: performance with query
Date
Msg-id 1245312129.5027.154.camel@dalmaso-opensuse.cl
Whole thread Raw
In response to Re: performance with query  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: performance with query
List 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


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: very slow selects on a small table
Next
From: Merlin Moncure
Date:
Subject: Re: enum for performance?