Postgres Pro
Downloads
Home   >   mailing lists

Re: database size much bigger than tablespaces on filesystem - Mailing list pgsql-admin

From Gabriele Bartolini
Subject Re: database size much bigger than tablespaces on filesystem
Date
Msg-id 2e8d367193927c050a3f33e22c0daa6f@2ndquadrant.it
Whole thread Raw
In response to database size much bigger than tablespaces on filesystem  (Rob Audenaerde <Rob.Audenaerde@Valuecare.nl>)
List pgsql-admin
Tree view 
 Hi,

 On Wed, 14 Sep 2011 04:03:45 -0700, Rob Audenaerde
 <Rob.Audenaerde@Valuecare.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.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it

pgsql-admin by date:

Previous
From: Rob Audenaerde
Date:
Subject: database size much bigger than tablespaces on filesystem
Next
From: Guillaume Lelarge
Date:
Subject: Re: database size much bigger than tablespaces on filesystem