Re: pg_wal filling up while running huge updates

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: aditya desai <admad123(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: pg_wal filling up while running huge updates
Date: 2022-08-05 14:04:00
Message-ID: 20220805140400.GQ19644@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Slava Mudry 2022-08-08 22:45:11 Re: Postgresql 14 partitioning advice
Previous Message Don Seiler 2022-08-05 13:56:52 Re: pg_wal filling up while running huge updates