Postgres Pro
Downloads
Home   >   mailing lists

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

From aditya desai
Subject pg_wal filling up while running huge updates
Date
Msg-id CAN0SRDGm2=ocC-iXvEbQ84voKzyQUvTBpU0j8LqU4Av7JU8ong@mail.gmail.com
Whole thread Raw
Responses Re: pg_wal filling up while running huge updates  (Don Seiler <don@seiler.us>)
Re: pg_wal filling up while running huge updates  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries
Next
From: Don Seiler
Date:
Subject: Re: pg_wal filling up while running huge updates