Re: Query much slower after upgrade to 9.6.1

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: Query much slower after upgrade to 9.6.1
Дата
Msg-id CAMjNa7cWH=rHs7x96wGfNd5DxzTtLyO-ZxZmia8MXaO+eQ1EzA@mail.gmail.com
обсуждение исходный текст
Ответ на Query much slower after upgrade to 9.6.1  (Adam Brusselback <adambrusselback@gmail.com>)
Ответы Re: Query much slower after upgrade to 9.6.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения
As suggested in the Postgres slack channel by lukasfittl, I disabled hashagg on my old server, and ran the query again. That changed one piece to a groupagg (like was used on the new server) and the performance was similar to the 9.6.1 box.

9.5.5 w/ hashagg disabled: https://explain.depesz.com/s/SBVt

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

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: Query much slower after upgrade to 9.6.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Query much slower after upgrade to 9.6.1