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" <Kevin.Grittner@wicourts.gov>)
Ответы Re: performance with query  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: very slow selects on a small table
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: enum for performance?