pg_wal filling up while running huge updates

Поиск
Список
Период
Сортировка
От aditya desai
Тема pg_wal filling up while running huge updates
Дата
Msg-id CAN0SRDGm2=ocC-iXvEbQ84voKzyQUvTBpU0j8LqU4Av7JU8ong@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_wal filling up while running huge updates
Re: pg_wal filling up while running huge updates
Список 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.

В списке pgsql-performance по дате отправления: