Re: performance with query

Поиск
Список
Период
Сортировка
Искать
От
Alberto Dalmaso
Тема
Re: performance with query
Дата
Msg-id
1245312129.5027.154.camel@dalmaso-opensuse.cl
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Tom Lane
Дата:
От: Merlin Moncure
Дата:
Сообщение: Re: enum for performance?
FAQ