| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | D Kavan <bitsandbytes88(at)hotmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: vacuumdb -a -f |
| Date: | 2005-08-17 18:59:37 |
| Message-ID: | 20050817185937.GE26491@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-17 20:40:18 | Re: Updateing pg_trigger and pg_constraint |
| Previous Message | D Kavan | 2005-08-17 18:15:42 | Re: vacuumdb -a -f |