Re: VACUUM FULL on 24/7 server

Gaetano Mendola wrote:

> Matthew T. O'Connor wrote:
>
>> Since you are running autovacuum I doubt the doing vacuumdb -a -z is 3
>> times a day buying you much.  It's not a bad idea to do once in a while.
>
>
> The reason is that I have few tables of about 5 milion with ~ 10000
> insert per
> day. Even with setting  -v 300 -V 0.1 this means these tables will be
> analyzed
> each 50 days. So I  have to force it.

I understand, but 10,000 new rows increate your table size only 0.2%, so
it won't significantly effect anything.  Also, if they really are just
inserts then vacuum is totally unnecessary.  I agree that for these
situations pg_autovacuum should be supplemented by vacuumdb -a -z every
once in a while, all I was pointing out was that 3 times a day is
probably excessive.

Matthew