Re: pg_wal filling up while running huge updates

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: pg_wal filling up while running huge updates
Дата
Msg-id 20220805140400.GQ19644@telsasoft.com
обсуждение исходный текст
Ответ на pg_wal filling up while running huge updates  (aditya desai <admad123@gmail.com>)
Список 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



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

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: pg_wal filling up while running huge updates
Следующее
От: Slava Mudry
Дата:
Сообщение: Re: Postgresql 14 partitioning advice