On-disk size of db increased after restore

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: On-disk size of db increased after restore
Date: 2010-08-31 21:17:04
Message-ID: 1283289424.2279.9.camel@hp-laptop2.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I tried to restore one of our db backups to 3 different machines today.

After restore, all machines reported larger on-disk size, and also
psql's \l+ confirmed that.

Here is the live machine:
On-disk size: 84 GB
Size reported by psql: 79 GB

Backup machine 1:

On-disk size: 162 GB
Size reported by psql: 177 GB

Backup machine 2:
On-disk size: 179 GB
Size reported by psql: 177 GB

I have seen the opposite of this tons of times before, but I haven't
seen an increase after restore before. Does anyone know what may cause
this? Where should I look at?

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vyacheslav Kalinin 2010-08-31 21:32:21 Re: Scalar subquery
Previous Message Peter Geoghegan 2010-08-31 17:32:04 Re: table - sequence dependent informatio