"Andrus" <kobruleht2(at)hot(dot)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