pg_dump with compressible and non-compressible tables

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump with compressible and non-compressible tables
Date: 2018-05-05 14:14:56
Message-ID: 235eb14a-c215-9a57-9e4d-adefef8fc0c1@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 just Store tables with bytea columns, while compressing all other tables
at the specified -Z level)?

Thanks

--
Angular momentum makes the world go 'round.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2018-05-05 14:47:40 Re: How to find the hits on the databases and tables in Postgres
Previous Message Christof Priller 2018-05-05 13:58:14 User defined functions in Postgresql, troubles with the c code