Re: performance with query
От
Alberto Dalmaso
Тема
Re: performance with query
Дата
Msg-id
1245312129.5027.154.camel@dalmaso-opensuse.cl
Ответ на
Re: performance with query (Kevin Grittner)
Список
Дерево обсуждения
Re: performance with query Alberto Dalmaso <dalmaso@clesius.it>
Re: performance with query "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: performance with query Alberto Dalmaso <dalmaso@clesius.it>
Re: performance with query "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: performance with query Alberto Dalmaso <dalmaso@clesius.it>
Re: performance with query "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: performance with query Tom Lane <tgl@sss.pgh.pa.us>
Re: performance with query "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
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 по дате отправления