Maurício Sessue Otta wrote:
Hi, in my production server a "du -hs" in the DATA directory returns 21GB in a newly installed server, after I restored the dumps from the production server, the "du -hs" gives me just 8GBwhy is there such a diference??? what should I do (besides buying bigger and bigger HDs) ??? []'s Mauricio
I had this same problem with 7.1.x, even doing full vacuums on SourceForge.net last year.
I assumed after a while that there was some hidden bug where file bloat occurred, despite the vacuum. After 3 months or so, you'd have to dump/restore the entire db and you'd be golden for a while again. After the dump/restore process things seemed much snappier too, and vacuum ran almost instantly.
I haven't verified if this problem still occurs in 7.2.x, using vacuum full.
Tim
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
