Re: Query became very slow after 9.6 -> 10 upgrade

From: Dmitry Shalashov <skaurus(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query became very slow after 9.6 -> 10 upgrade
Date: 2017-11-25 11:54:55
Message-ID: CAKPeCUH72oDs4BqkcXYaaGFjygykdifn0xsPF-YPuVuOP1FcaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)sss(dot)pgh(dot)pa(dot)us>:

> Dmitry Shalashov <skaurus(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2017-11-25 12:13:42 Re: Query became very slow after 9.6 -> 10 upgrade
Previous Message Michael Paquier 2017-11-25 10:52:42 Re: [HACKERS] More stats about skipped vacuums

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Paquier 2017-11-25 12:13:42 Re: Query became very slow after 9.6 -> 10 upgrade
Previous Message Gábor SZŰCS 2017-11-25 09:19:59 Re: insert and query performance on big string table with pg_trgm