Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_wal filling up while running huge updates - Mailing list pgsql-performance

From Don Seiler
Subject Re: pg_wal filling up while running huge updates
Date
Msg-id CAHJZqBBMZfL9Z9Dig9HkQ1OQYxtNcobyA+T_KH1zWhSwiQeGqg@mail.gmail.com
Whole thread Raw
In response to pg_wal filling up while running huge updates  (aditya desai <admad123@gmail.com>)
List pgsql-performance
Tree view
On Fri, Aug 5, 2022 at 7:30 AM aditya desai <admad123@gmail.com> wrote:

We are doing an oracle to postgres migration(5 TB+ data). We are encoding and decoding BLOB data after migration and for that we are running updates on tables having BLOB/CLOB data. When we execute this pg_wal is filling up. 

Do you have any general guidelines for migrating a 5TB + database from Oracle to Postgres? Any specific guidelines around archiving logs?

If you use pgBackrest for WAL archiving, you could enable asynchronous archiving.


--
Don Seiler
www.seiler.us

pgsql-performance by date:

Previous
From: aditya desai
Date:
Subject: pg_wal filling up while running huge updates
Next
From: Justin Pryzby
Date:
Subject: Re: pg_wal filling up while running huge updates