AW: archiving question
"Zwettler Markus (OIZ)" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
> > Greetings, > > * Zwettler Markus (OIZ) ([email protected]) 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?