public inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Johannes Graën <johannes@selfnet.de>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: performance drop after upgrade (9.6 > 10)
Date: Tue, 24 Oct 2017 17:57:31 +0200
Message-ID: <e0592313-750d-64ea-84cf-699471956729@selfnet.de> (raw)
In-Reply-To: <20171024151803.GH21735@telsasoft.com>
References: <CA++JNSeCW1BSRVS7N--OmVOMDiMVA61_DFMA24fFbM2R7JdQjQ@mail.gmail.com>
<CAFj8pRDnW+bD5OmWjawxryv_=BctsE8HF5Y1n=oxgQ+xwrVqUQ@mail.gmail.com>
<CA++JNScUoxYKBhURxbG_DzoUfgKJup4a4TXUTiG1FFjuq8X-VQ@mail.gmail.com>
<CA++JNSfTEifSiBq73zpGCQuDNGr9yYcjmkx_=LtAbnadKLY_vg@mail.gmail.com>
<20171024151803.GH21735@telsasoft.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 2017-10-24 17:18, Justin Pryzby wrote:
> You could (re)install PG96 alongside PG10 and run a copy of the DB (even from
> your homedir, or on a difference server) and pg_dump |pg_restore the relevant
> tables (just be sure to specify the alternate host/port/user/etc as needed for
> the restore invocation).
I considered that but it is far too expensive just for getting the old
query plan. The database is more than 1 TB big and replaying it from a
dump to another server took us several days, primarily due to the heavy
use of materialized views that are calculated over all rows of some
large tables. As long as there is no safe pg_downgrade --link I'd rather
keep trying to improve query performance on the current version.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: johannes@selfnet.de, pryzby@telsasoft.com, pavel.stehule@gmail.com
Subject: Re: performance drop after upgrade (9.6 > 10)
In-Reply-To: <e0592313-750d-64ea-84cf-699471956729@selfnet.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox