>Andrew Dunstan <andrew@dunslane.net> writes:
>> Hmm. Yeah. It looks like commit a7ad5cf0cfcfab8418000d652fa4f0c6ad6c8911
>> changed from using the default compression for libz to using the
>> compression set in pg_dump options, which defaults to 0. This actually
>> seems like the right thing to do, but it certainly should have been
>> called out much more forcefully in release notes, and arguably should
>> not have been changed in stable releases. Not sure what we do about it now.
really 0? wouldn't that mean no compression at all?
>I don't think we realized that we were changing the default behavior.
>Still, it's clearly a bug fix, so I'm disinclined to revert it now.
>
> regards, tom lane
Sure, but at least the doc should be modified as it suggests that a higher compression is used:
"the default is to compress at a moderate level"
=>
"the default is to compress at the lowest level"
And maybe a quick notice for planet Postgres to highlight the modification of the default behavior.
(I' haven't a blog myself ...)
IMHO a slightly higher default would help spare some hardware out there...
regards,
Marc Mamin