Postgres Pro
Downloads
Home   >   mailing lists

Re: Query much slower after upgrade to 9.6.1 - Mailing list pgsql-performance

From Adam Brusselback
Subject Re: Query much slower after upgrade to 9.6.1
Date
Msg-id CAMjNa7cWH=rHs7x96wGfNd5DxzTtLyO-ZxZmia8MXaO+eQ1EzA@mail.gmail.com
Whole thread Raw
In response to Query much slower after upgrade to 9.6.1  (Adam Brusselback <adambrusselback@gmail.com>)
Responses Re: Query much slower after upgrade to 9.6.1
List pgsql-performance
Tree view
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 by date:

Previous
From: Adam Brusselback
Date:
Subject: Query much slower after upgrade to 9.6.1
Next
From: Tom Lane
Date:
Subject: Re: Query much slower after upgrade to 9.6.1