Postgres Pro
Downloads
Home   >   mailing lists

Re: Does it has a way to compact the database size? - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Does it has a way to compact the database size?
Date
Msg-id 20070306091536.GH10330@a-kretschmer.de
Whole thread Raw
In response to Does it has a way to compact the database size?  ("Premsun Choltanwanich" <Premsun@nsasia.co.th>)
List pgsql-general
Tree view 
am  Tue, dem 06.03.2007, um 15:28:01 +0700 mailte Premsun Choltanwanich folgendes:
> Dear All,
>
> I use PostgreSQL 8.0.3 for store my data started on Sep'06. Today, I
> use database_size('name') function for checking my database size and
> found that it's about 1209715345.
> ...
> Any Idea?

Yes, you need VACUUM or VACUUM FULL, regular. Check, if autovacuum runs.
(see in the log)


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: "Premsun Choltanwanich"
Date:
Subject: Does it has a way to compact the database size?
Next
From: Richard Huxton
Date:
Subject: Re: Does it has a way to compact the database size?