Postgres Pro
Downloads
Home   >   mailing lists

pg_dump with compressible and non-compressible tables - Mailing list pgsql-general

From Ron
Subject pg_dump with compressible and non-compressible tables
Date
Msg-id 235eb14a-c215-9a57-9e4d-adefef8fc0c1@gmail.com
Whole thread Raw
Responses Re: pg_dump with compressible and non-compressible tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Christof Priller
Date:
Subject: User defined functions in Postgresql, troubles with the c code
Next
From: Melvin Davidson
Date:
Subject: Re: How to find the hits on the databases and tables in Postgres