Re: performance with query

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: performance with query
Дата
Msg-id 4A3774C40200002500027BED@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: performance with query  (Alberto Dalmaso <dalmaso@clesius.it>)
Список pgsql-performance
Alberto Dalmaso <dalmaso@clesius.it> wrote:
> Il giorno mar, 16/06/2009 alle 15.58 +0100, Matthew Wakeling ha
> scritto:
>> On Tue, 16 Jun 2009, Alberto Dalmaso wrote:

>> > 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.

These really are meant primarily for diagnostic purposes.  As a last
resort, you could set them off right before running a problem query,
and set them back on again afterward; but you will be much better off
if you can cure the underlying problem.  The best chance of that is to
show us the plan you get with all turned on.

-Kevin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: performance with query
Следующее
От: Alberto Dalmaso
Дата:
Сообщение: Re: performance with query