Re: archiving question - Mailing list pgsql-general

From Stephen Frost
Subject Re: archiving question
Date
Msg-id 20191204175618.GH6962@tamriel.snowman.net
Whole thread Raw
In response to archiving question  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Responses AW: archiving question
List 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

Attachment

pgsql-general by date:

Previous
From: "Zwettler Markus (OIZ)"
Date:
Subject: archiving question
Next
From: "Hu, Patricia"
Date:
Subject: what causes xact_rollback for a database in pg_stat_database toincrement?