Re: archiving question

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: archiving question
Дата
Msg-id 20191204175618.GH6962@tamriel.snowman.net
обсуждение исходный текст
Ответ на archiving question  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Ответы AW: archiving question  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Список pgsql-general
Greetings,

* Zwettler Markus (OIZ) (Markus.Zwettler@zuerich.ch) wrote:
> When there is a Postgres archiver stuck because of filled pg_xlog and archive directories...
>
> ... and the pg_xlog directory had been filled with dozens of GBs of xlogs...
>
> ...it takes ages until the archive_command had moved all xlogs from the pg_xlog directory to the archive directory
afterwards...
>
> ... and you get crazy if you have a 8GB archive directory while the pg_xlog directory had been pumped up to 100GB :(
>
>
> Any idea on this one?

Parallelizing the archive-push operation can be quite helpful to address
this.

Thanks,

Stephen

Вложения

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

Предыдущее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: archiving question
Следующее
От: "Hu, Patricia"
Дата:
Сообщение: what causes xact_rollback for a database in pg_stat_database toincrement?