Re: archiving question
Stephen Frost <[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
signature.asc
(application/pgp-signature, 819 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJd5/NBAAoJEO1sijiDR2RV1c8QAKAeaXjKi8vIcEaiLesmMKlH MS2Y/Y579Kd/dITs7IxoBWXzgP15Z3QeBQ8XKlKikq2R90MU+GRVqMDWrsLPtcp0 4mPJdS6LTbFx98cNAjIMtOH+T6NFm8iZko4TuIoOhFBnzG4DeveU9GOOFy7KI0do eXswx9IopK5g6NWjcjZdzUuZvwVL1aLX5BrI+po1F2ITNuD0In655hZME/ZhMXej 8BW8HHSHWgW2uorqhcSl/Hlz66LYhLbAAdez5KHxbs3UFa8XKRSq6vo2P+4CCORN 1SU2vgtnd+9Jo1JogAkpNPqAa8LFpa3YFanCl6VyLbuHLuxbGKM82OUU+0wn3fjN 6HzIFt5V5omkNEna0cF8SkzsM+fZdpsx5CHKjajRmat4RHZM/tgLv0IewhyWQwUd JsWEpKBV0d3RA1FyKUx5wpXHkcZHCXLEL229n9gMxpyaiqiKdRooFgDtUdlgJy5z 35NwtqnexmLX4KxNS4kx9HyYg2hwMMuMQvjzqGzgwtpJxpqNHQ2o+98c2aod0S5T fN/euHcSqqR2+yV8S4z8+Z+naOQvKp289QWeEK5K6w299O0pV3S8t75IsVlBi7+J B6UVs0EQ5mt9b0bKAndgELBy+1WWWrj7PnPqhhlraAWTgZ7O2ZRIQPgZSSAPdqk5 e2cOsSOVhp6n28Ps4lIZ =GYET -----END PGP SIGNATURE-----