pg_wal filling up while running huge updates

From: aditya desai <admad123(at)gmail(dot)com>
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: pg_wal filling up while running huge updates
Date: 2022-08-05 12:30:02
Message-ID: CAN0SRDGm2=ocC-iXvEbQ84voKzyQUvTBpU0j8LqU4Av7JU8ong@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 from
Oracle to Postgres? Any specific guidelines around archiving logs?

Regards,
Aditya.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Don Seiler 2022-08-05 13:56:52 Re: pg_wal filling up while running huge updates
Previous Message Tom Lane 2022-08-03 15:17:05 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries