Re: pg_dump with compressible and non-compressible tables

2018-05-05 Thread Adrian Klaver
On 05/05/2018 12:41 PM, Ron wrote: On 05/05/2018 12:13 PM, Adrian Klaver wrote: On 05/05/2018 07:14 AM, Ron wrote: Hi, v9.6 We've got big databases where some of the tables are highly compressible, but some have many bytea fields containing PDF files. Can you see a demonstrable difference?

Re: pg_dump with compressible and non-compressible tables

2018-05-05 Thread Ron
On 05/05/2018 12:13 PM, Adrian Klaver wrote: On 05/05/2018 07:14 AM, Ron wrote: Hi, v9.6 We've got big databases where some of the tables are highly compressible, but some have many bytea fields containing PDF files. Can you see a demonstrable difference? Very much so.  The ASCII hex repr

Re: pg_dump with compressible and non-compressible tables

2018-05-05 Thread Adrian Klaver
On 05/05/2018 07:14 AM, Ron wrote: Hi, v9.6 We've got big databases where some of the tables are highly compressible, but some have many bytea fields containing PDF files. Can you see a demonstrable difference? When the data format is custom, directory or tar, how feasible would a "--no-

pg_dump with compressible and non-compressible tables

2018-05-05 Thread Ron
Hi, v9.6 We've got big databases where some of the tables are highly compressible, but some have many bytea fields containing PDF files. When the data format is custom, directory or tar, how feasible would a "--no-blob-compression" option be (where pg_dump just tells the zlib library to jus