Re: On-disk size of db increased after restore

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: On-disk size of db increased after restore
Date: 2010-09-01 00:08:19
Message-ID: AANLkTikv92RujZnT=TDuYCsnybxuD4mk47Eh1SkmUiqO@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/8/31 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>:
>
> 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

They're about 2x as big. Any chance you've restored to different dbs
and have two copies? Or double the data in one db?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2010-09-01 00:09:40 Re: Table update problem works on MySQL but not Postgres
Previous Message Raymond C. Rodgers 2010-08-31 23:56:23 Table update problem works on MySQL but not Postgres