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-