Re: performance with query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: performance with query
Дата
Msg-id 15480.1245166290@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: performance with query  (Alberto Dalmaso <dalmaso@clesius.it>)
Ответы Re: performance with query  (Alberto Dalmaso <dalmaso@clesius.it>)
Список pgsql-performance
Alberto Dalmaso <dalmaso@clesius.it> writes:
> Il giorno mar, 16/06/2009 alle 15.58 +0100, Matthew Wakeling ha scritto:
>>> enable_hashjoin = off
>>> enable_nestloop = off
>>> enable_seqscan = off
>>> enable_sort = off
>>
>> Why are these switched off?
>>
> because of the need to pump up the performance of the complex query.

That is *not* the way to improve performance of a query.  Turning off
specific enable_ parameters can be helpful while investigating planner
behavior, but it is never recommended as a production solution.  You
have already found out why.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Alexander Staubo
Дата:
Сообщение: Re: Yet another slow nested loop
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: performance with query