From: Justin Pryzby <pryzby@telsasoft.com>
To: Westwood, Giles <g.westwood@orcid.org>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Performance for initial copy when using pg_logical to upgrade Postgres
Date: Fri, 24 Sep 2021 09:39:35 -0500
Message-ID: <20210924143934.GN831@telsasoft.com> (raw)
In-Reply-To: <CAEMahfP0FCUUuFrDY7gpacwSRp_jM7eNCA__kbVeMupWShE=8A@mail.gmail.com>
References: <CAEMahfP0FCUUuFrDY7gpacwSRp_jM7eNCA__kbVeMupWShE=8A@mail.gmail.com>
On Fri, Sep 24, 2021 at 03:28:50PM +0100, Westwood, Giles wrote:
> At Orcid we're trying to upgrade our Postgres database (10 to 13) using
> pg_logical for no downtime. The problem we have is how long the initial
> copy is taking for the ~500GB database. If it takes say 20days to complete,
> will we need to have 20days of WAL files to start catching up when it's
> complete?
Did you see this thread and its suggestions to 1) set bulk load parameters;
and, 2) drop indexes and FKs ?
https://www.postgresql.org/message-id/flat/4A8EFC4E-A264-457D-A8E7-AE324ED9ABD4@thebuild.com
--
Justin
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: pryzby@telsasoft.com, g.westwood@orcid.org, pgsql-performance@lists.postgresql.org
Subject: Re: Performance for initial copy when using pg_logical to upgrade Postgres
In-Reply-To: <20210924143934.GN831@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox