Re: vacuumdb -a -f - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: vacuumdb -a -f
Date
Msg-id 20050817185937.GE26491@alvh.no-ip.org
Whole thread Raw
In response to Re: vacuumdb -a -f  ("D Kavan" <bitsandbytes88@hotmail.com>)
List pgsql-admin
On Wed, Aug 17, 2005 at 02:15:42PM -0400, D Kavan wrote:
>
> 'du -h' in the base directory.
>
> >How are you finding out the DB size?

You are considering the difference in XLog segment size, right?  The
pg_xlog directory may start almost empty and then start filling.  The
space will not be recovered by any maintenance command.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí."
"Y que hayan abogados, para que la gente no culpe de todo a Satanás"

pgsql-admin by date:

Previous
From: Craig Servin
Date:
Subject: Updateing pg_trigger and pg_constraint
Next
From: Tom Lane
Date:
Subject: Re: Updateing pg_trigger and pg_constraint