Re: database size grows (even after vacuum (full and - Mailing list pgsql-novice

From Joao Miguel Ferreira
Subject Re: database size grows (even after vacuum (full and
Date
Msg-id 1147096585.2418.61.camel@sandoval
Whole thread Raw
In response to Re: database size grows (even after vacuum (full and analyze))....  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi Tom and all,

> I wrote that on my original e-mail: I do a "VACUUM ANALYZE" every 30
> > minutes and a "VACUUM FULL" every 2 hours.
>
> That's not a good maintenance procedure.  Just do the plain vacuums and
> forget the VACUUM FULL.  If the table row count is fairly stable then
> plain vacuums are all you need.  I suspect VACUUM FULL is making things
> worse not better --- it'll compact the tables, but at the price of
> bloating the indexes.
>
> You might want to pay some attention to exactly where the space is
> disappearing to --- which files are getting bigger?

Sorry for the long silence. I've been making experiments and reading
about all of this. The 'data' directory is the one growing in size.

>
> If you find you are suffering from index bloat, a very occasional
> REINDEX (maybe once a week or less) will fix that, but VACUUM FULL
> won't help it at all.  I wouldn't recommend doing this unless
> proven necessary, however.

I've checked (and read about) REINDEX and applied it. Nevertheless I
still get a litlle continuous growth (about 200Bytes/minute) in the
'data' directory. I must say: REINDEX causes a sudden drop in filesystem
usage but (about 30 minutes later) size returns to where it droped and
continues growing.

What would you say I'dd do next ?

thx
jmf


PS: this problem brought me to an excelent book about Pg. I'm suprised
with the great things I didn't know about Pg...

>
>             regards, tom lane


pgsql-novice by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Trigger function to change data to correct datatype
Next
From: Sean Davis
Date:
Subject: Re: Trigger function to change data to correct datatype