Re: pg_dump file size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike angelo <angelocmp(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump file size
Date: 2009-04-14 15:40:47
Message-ID: 11681.1239723647@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mike angelo <angelocmp(at)yahoo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-04-14 16:48:20 Re: Do the name of the WAL files matter?
Previous Message Isabella Ghiurea 2009-04-14 15:38:42 pg error log file monitor