Horton

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

Michael Paquier <michael.paquier@gmail.com>

View thread View on postgr.es
From: Michael Paquier <michael.paquier@gmail.com>
To: Dmitry Shalashov <skaurus@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2017-11-25T12:13:42Z
Lists: pgsql-hackers, pgsql-performance 
On Sat, Nov 25, 2017 at 8:54 PM, Dmitry Shalashov <skaurus@gmail.com> wrote:
> Is it completely safe to use manually patched version in production?

Patching upstream PostgreSQL to fix a critical bug is something that
can of course be done. And to reach a state where you think something
is safe to use in production first be sure to test it thoroughly on a
stage instance. The author is also working on Postgres for 20 years,
so this gives some insurance.
-- 
Michael

Commits

  1. Improve planner's handling of set-returning functions in grouping columns.