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:
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
>>
>> On Thu, Dec 05, 2019 at 03:04:55PM +, Zwettler Markus (OIZ) wrote:
&g
> 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
> -Ursprüngliche Nachricht-
> Von: Michael Paquier
> Gesendet: Freitag, 6. Dezember 2019 02:43
> An: Zwettler Markus (OIZ)
> Cc: Stephen Frost ; pgsql-general@lists.postgresql.org
> Betreff: Re: archiving question
>
> On Thu, Dec 05, 2019 at 03:04:55PM +, Zwe
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
>
> 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 unti
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
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
