Re: pg_wal filling up while running huge updates

2022-08-05 Thread Justin Pryzby
On Fri, Aug 05, 2022 at 06:00:02PM +0530, aditya desai wrote: > Hi, > 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.

Re: pg_wal filling up while running huge updates

2022-08-05 Thread Don Seiler
On Fri, Aug 5, 2022 at 7:30 AM aditya desai 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 ha

pg_wal filling up while running huge updates

2022-08-05 Thread aditya desai
Hi, 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 fro