Re: Performance for initial copy when using pg_logical to upgrade Postgres

From: "Westwood, Giles" <g(dot)westwood(at)orcid(dot)org>
To:
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Performance for initial copy when using pg_logical to upgrade Postgres
Date: 2021-09-24 15:48:45
Message-ID: CAEMahfOCN=swG8dd6Szdv85seGOctAHOkcRmt4hpi-X4ZgiYwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Sep 24, 2021 at 3:39 PM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:

> On Fri, Sep 24, 2021 at 03:28:50PM +0100, Westwood, Giles wrote:
>
> 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(at)thebuild(dot)com
>
>
I did actually but I wanted to avoid getting my hands dirty with anything
schema wise. I've found another person with another similar situation:-

https://github.com/2ndQuadrant/pglogical/issues/325

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Dunstan 2021-09-24 16:00:42 Re: Performance for initial copy when using pg_logical to upgrade Postgres
Previous Message Justin Pryzby 2021-09-24 14:39:35 Re: Performance for initial copy when using pg_logical to upgrade Postgres