Re: Performance problems with 9.2.15

От: Johan Fredriksson
Тема: Re: Performance problems with 9.2.15
Дата: ,
Msg-id: 1469149167892.29906@kth.se
(см: обсуждение, исходный текст)
Ответ на: Re: Performance problems with 9.2.15  (Claudio Freire)
Ответы: Re: Performance problems with 9.2.15  (Johan Fredriksson)
Список: pgsql-performance

Скрыть дерево обсуждения

Performance problems with 9.2.15  (Johan Fredriksson, )
 Re: Performance problems with 9.2.15  (Tom Lane, )
  Re: Performance problems with 9.2.15  (Johan Fredriksson, )
   Re: Performance problems with 9.2.15  (Steve Crawford, )
  Re: Performance problems with 9.2.15  (Johan Fredriksson, )
   Re: Performance problems with 9.2.15  (Johan Fredriksson, )
    Re: Performance problems with 9.2.15  (Johan Fredriksson, )
     Re: Performance problems with 9.2.15  (Claudio Freire, )
      Re: Performance problems with 9.2.15  ("David G. Johnston", )
       Re: Performance problems with 9.2.15  (Claudio Freire, )
        Re: Performance problems with 9.2.15  (Johan Fredriksson, )
         Re: Performance problems with 9.2.15  (Johan Fredriksson, )
          Re: Performance problems with 9.2.15  (Mark Kirkwood, )
           Re: Performance problems with 9.2.15  (Johan Fredriksson, )

I can add that setting enable_nestloop = 0 cuts the runtime for this query down to about 4 seconds.
Disabling nested loops globaly does however impacts performance of a lot of other queries.

        / Eskil


В списке pgsql-performance по дате сообщения:

От: Johan Fredriksson
Дата:
Сообщение: Re: Performance problems with 9.2.15
От: Mark Kirkwood
Дата:
Сообщение: Re: Performance problems with 9.2.15