From: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
To: Rob Audenaerde <Rob.Audenaerde@Valuecare.nl>
Cc: pgsql-admin@postgresql.org
Subject: Re: database size much bigger than tablespaces on filesystem
Date: Wed, 14 Sep 2011 13:55:42 +0200
Message-ID: <2e8d367193927c050a3f33e22c0daa6f@2ndquadrant.it> (raw)
In-Reply-To: <1D020918205F334CBDD5CE7DF2038A2E15A5812457@IE2RD2XVS271.red002.local>
References: <1D020918205F334CBDD5CE7DF2038A2E15A5812457@IE2RD2XVS271.red002.local>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Gabriele.Bartolini@2ndQuadrant.it, Rob.Audenaerde@Valuecare.nl
Subject: Re: database size much bigger than tablespaces on filesystem
In-Reply-To: <2e8d367193927c050a3f33e22c0daa6f@2ndquadrant.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox