"Andrus" <kobruleht2@xxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
