AW: archiving question

Поиск
Список
Период
Сортировка
От Zwettler Markus (OIZ)
Тема AW: archiving question
Дата
Msg-id 200ee00c33104728b9a6b8df8ca90226@zuerich.ch
обсуждение исходный текст
Ответ на Re: archiving question  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: archiving question  (Michael Paquier <michael@paquier.xyz>)
Список 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


What do you mean hear?

Afaik, Postgres runs the archive_command per log, means log by log by log.

How should we parallelize this?




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

Предыдущее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: AW: secure deletion of archived logs
Следующее
От: Tom Lane
Дата:
Сообщение: Re: We have to close the cursor or rollback the transaction in case of failure?