Re: Different size in the DATA directory

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 8GB
>
> why 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