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@xxxxxxxxxxxx -- Justin
