Re:Wal-E: Continuous Archiving for Postgres
by icebraining on Sunday February 05, 2017 @05:38PM
(#13575122)
AFAIK the dynamic WAL sizing has already landed in 9.5: http://www.databasesoup.com/2016/01/configuration-changes-in...
Or is this something else you're talking about?
Re:Wal-E: Continuous Archiving for Postgres
by user5994461 on Monday February 06, 2017 @01:52PM
(#13582671)
Yes, I'm talking about that and it's in 9.5 (which was released recently)
Compression is enabled indeed. Surprisingly, the compression ratio for "nothing going on" is terrible. (still multiple MBytes).
The next version of postgre will redo the transaction log to have dynamic adaptive sizing, with new settings to control it. Not there yet.