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
|
Список | 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 по дате отправления: