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

От: Tom Lane
Тема: Re: Query became very slow after 9.6 -> 10 upgrade
Дата: ,
Msg-id: 28356.1511541575@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov)
Ответы: Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov)
Список: pgsql-performance

Скрыть дерево обсуждения

Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
 RE: Query became very slow after 9.6 -> 10 upgrade  ("Alex Ignatov", )
  Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
   RE: Query became very slow after 9.6 -> 10 upgrade  ("Alex Ignatov", )
    Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
     Re: Query became very slow after 9.6 -> 10 upgrade  (Tomas Vondra, )
 Re: Query became very slow after 9.6 -> 10 upgrade  (Tom Lane, )
  Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
   Re: Query became very slow after 9.6 -> 10 upgrade  (Tom Lane, )
    Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
     Re: Query became very slow after 9.6 -> 10 upgrade  (Tom Lane, )
      Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
       Re: Query became very slow after 9.6 -> 10 upgrade  (Tom Lane, )
        Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
         Re: Query became very slow after 9.6 -> 10 upgrade  (Michael Paquier, )
          Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
          Re: Query became very slow after 9.6 -> 10 upgrade  (Tom Lane, )
           Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
    Re: Query became very slow after 9.6 -> 10 upgrade  (Dmitry Shalashov, )
   Re: Query became very slow after 9.6 -> 10 upgrade  (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 по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Query became very slow after 9.6 -> 10 upgrade
От: Jeff Janes
Дата:
Сообщение: Re: insert and query performance on big string table with pg_trgm