Re: archiving question

2019-12-06 Thread Magnus Hagander
o:mich...@paquier.xyz> > >> Gesendet: Freitag, 6. Dezember 2019 02:43 > >> An: Zwettler Markus (OIZ) <mailto:markus.zwett...@zuerich.ch> > >> Cc: Stephen Frost <mailto:sfr...@snowman.net>; mailto: > pgsql-general@lists.postgresql.org > >> Betreff:

Re: archiving question

2019-12-06 Thread Magnus Hagander
> pgsql-general@lists.postgresql.org > > Betreff: Re: archiving question > > > > On Thu, Dec 05, 2019 at 03:04:55PM +, Zwettler Markus (OIZ) wrote: > > > What do you mean hear? > > > > > > Afaik, Postgres runs the archive_command per log, means log by

Re: archiving question

2019-12-05 Thread Michael Paquier
On Thu, Dec 05, 2019 at 03:04:55PM +, Zwettler Markus (OIZ) wrote: > What do you mean hear? > > Afaik, Postgres runs the archive_command per log, means log by log by log. > > How should we parallelize this? You can, in theory, skip the archiving for a couple of segments and then do the opera

Re: archiving question

2019-12-04 Thread Stephen Frost
Greetings, * Zwettler Markus (OIZ) (markus.zwett...@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