Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance for initial copy when using pg_logical to upgrade Postgres - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: Performance for initial copy when using pg_logical to upgrade Postgres
Date
Msg-id 20210924143934.GN831@telsasoft.com
Whole thread Raw
In response to Performance for initial copy when using pg_logical to upgrade Postgres  ("Westwood, Giles" <g.westwood@orcid.org>)
Responses Re: Performance for initial copy when using pg_logical to upgrade Postgres  ("Westwood, Giles" <g.westwood@orcid.org>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Westwood, Giles"
Date:
Subject: Performance for initial copy when using pg_logical to upgrade Postgres
Next
From: "Westwood, Giles"
Date:
Subject: Re: Performance for initial copy when using pg_logical to upgrade Postgres