Re: Query became very slow after 9.6 -> 10 upgrade - Mailing list pgsql-performance

From Dmitry Shalashov
Subject Re: Query became very slow after 9.6 -> 10 upgrade
Date
Msg-id CAKPeCUH72oDs4BqkcXYaaGFjygykdifn0xsPF-YPuVuOP1FcaA@mail.gmail.com
Whole thread Raw
In response to Re: Query became very slow after 9.6 -> 10 upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Query became very slow after 9.6 -> 10 upgrade  (Michael Paquier <michael.paquier@gmail.com>)
List 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 : > Dmitry Shalashov 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 >

pgsql-performance by date:

Previous
From: Gábor SZŰCS
Date:
Subject: Re: insert and query performance on big string table with pg_trgm
Next
From: Michael Paquier
Date:
Subject: Re: Query became very slow after 9.6 -> 10 upgrade