Re: database size much bigger than tablespaces on filesystem

From: Gabriele Bartolini <Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it>
To: Rob Audenaerde <Rob(dot)Audenaerde(at)Valuecare(dot)nl>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: database size much bigger than tablespaces on filesystem
Date: 2011-09-14 11:55:42
Message-ID: 2e8d367193927c050a3f33e22c0daa6f@2ndquadrant.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

On Wed, 14 Sep 2011 04:03:45 -0700, Rob Audenaerde
<Rob(dot)Audenaerde(at)Valuecare(dot)nl> wrote:
> Is this corruption of the database? Or are there ways to 'fix' this
> oddity?

Try VACUUM ANALYSE and repeat the operation.

Thanks,
Gabriele

--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it - www.2ndQuadrant.it

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2011-09-14 12:00:15 Re: database size much bigger than tablespaces on filesystem
Previous Message Rob Audenaerde 2011-09-14 11:03:45 database size much bigger than tablespaces on filesystem