Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump file size - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump file size
Date
Msg-id 11681.1239723647@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump file size  (Mike angelo <angelocmp@yahoo.com>)
List pgsql-admin
Tree view 
Mike angelo <angelocmp@yahoo.com> writes:
> Curious as to how the backup file can be less than 1/10th the size of the database?

The dump doesn't contain indexes (only commands to create them).
You might also be suffering a bit of table and/or index bloat
in the database.

            regards, tom lane

pgsql-admin by date:

Previous
From: Mike angelo
Date:
Subject: pg_dump file size
Next
From: Isabella Ghiurea
Date:
Subject: pg error log file monitor