Postgres Pro
Downloads
Home   >   mailing lists

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

From Justin Pryzby
Subject Re: pg_wal filling up while running huge updates
Date
Msg-id 20220805140400.GQ19644@telsasoft.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 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.

Could you please include basic information in each new thread you create ?

https://wiki.postgresql.org/wiki/Server_Configuration
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-- 
Justin

pgsql-performance by date:

Previous
From: Don Seiler
Date:
Subject: Re: pg_wal filling up while running huge updates
Next
From: Slava Mudry
Date:
Subject: Re: Postgresql 14 partitioning advice