Re: Query became very slow after 9.6 -> 10 upgrade
Dmitry Shalashov <skaurus@gmail.com>
From: Dmitry Shalashov <skaurus@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2017-11-25T11:54:55Z
Lists: pgsql-hackers, pgsql-performance
> Excellent, please follow up if you learn anything new. Sure. But my testing is over and something new might come out only incidentally now. Testing hasn't reveal anything interesting. > That will probably be in > early February, per our release policy: ok, thanks. That makes me kinda hope for some security problem :) Is it completely safe to use manually patched version in production? Dmitry Shalashov, relap.io & surfingbird.ru 2017-11-24 19:39 GMT+03:00 Tom Lane <tgl@sss.pgh.pa.us>: > Dmitry Shalashov <skaurus@gmail.com> writes: > > It looks that patch helps us. Tom, thank you! > > I'm still testing it though, just in case. > > Excellent, please follow up if you learn anything new. > > > What are PostgreSQL schedule on releasing fixes like this? Can I expect > > that it will be in 10.2 and when can I expect 10.2, approximately of > course? > > I haven't pushed it to the git repo yet, but I will shortly, and then > it will be in the next minor release. That will probably be in > early February, per our release policy: > https://www.postgresql.org/developer/roadmap/ > > regards, tom lane >
Commits
-
Improve planner's handling of set-returning functions in grouping columns.
- df3a66e282b6 11.0 landed
- b9fc2d0b97c1 10.2 landed