Re: Compressed Backup too big - Mailing list pgsql-general

From Tom Lane
Subject Re: Compressed Backup too big
Date
Msg-id 6519.1195409849@sss.pgh.pa.us
Whole thread Raw
In response to Compressed Backup too big  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
"Andrus" <kobruleht2@hot.ee> writes:
> I created query returning biggest tables with and without indexes and found:

>       1  pg_toast_22185                      95 MB           96 MB

> 1. Tables are relatively small and thus cannot create 125 MB compressed
> backup file.

You have failed to consider that data that goes into a toast table is
usually compressed first.  The above table is probably accounting for
close to 100MB of compressed dump output.

            regards, tom lane

pgsql-general by date:

Previous
From: Oliver Kohll
Date:
Subject: Fwd: max_fsm_relations
Next
From: Tom Lane
Date:
Subject: Re: ERROR: invalid restriction selectivity: 224359728.000000