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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
