Re: Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off?

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off?
Дата
Msg-id 20220513124113.GT19626@telsasoft.com
обсуждение исходный текст
Ответ на Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off?  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Fri, May 06, 2022 at 09:50:26PM +0530, Bharath Rupireddy wrote:
> It seems like that's not the case because postgres will not remove future WAL
> files even after max_wal_size is reduced,

In the past, I've had to generate synthetic write traffic and checkpoints to
get WAL to shrink.  +1 to make it respect max_wal_size on its own.

-- 
Justin

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

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Unfiltered server logs routing via a new elog hook or existing emit_log_hook bypassing log_min_message check
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Comments on Custom RMGRs