From: | Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: database size grows (even after vacuum (full and |
Date: | 2006-05-03 18:19:47 |
Message-ID: | 1146680387.2340.111.camel@sandoval |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
ok, I understand that.
Thank you. I'll try it.
joao
On Wed, 2006-05-03 at 19:12, Tom Lane wrote:
> Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt> writes:
> > On Wed, 2006-05-03 at 15:45, Bruno Wolff III wrote:
> >> 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.
>
> 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?
>
> 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.
>
> regards, tom lane
thx
joao
From | Date | Subject | |
---|---|---|---|
Next Message | Florian G. Pflug | 2006-05-03 18:20:55 | Re: The planner chooses seqscan+sort when there is an |
Previous Message | Tom Lane | 2006-05-03 18:12:19 | Re: database size grows (even after vacuum (full and analyze)).... |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2006-05-03 20:07:21 | Re: database size grows (even after vacuum (full and analyze)).... |
Previous Message | Tom Lane | 2006-05-03 18:12:19 | Re: database size grows (even after vacuum (full and analyze)).... |