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

On Wed, 2006-05-03 at 15:45, Bruno Wolff III wrote:
> On Wed, May 03, 2006 at 12:02:18 +0100,
>   Joao Miguel Ferreira <jmf@estg.ipvc.pt> wrote:
> > certain life time for each record).
> >
> > Dispite this, the file system size still grows (at about 500KB in about
> > 1000 minutes).
>
> How often are you vacuuming the table?

I wrote that on my original e-mail: I do a "VACUUM ANALYZE" every 30
minutes and a "VACUUM FULL" every 2 hours.

Should I do anything else ? Thanks.

tahnks

joao