Re: Vacuum is looping on tables?

Michael Guerin <guerin@rentec.com> writes:
>    I've noticed that vacuum seems to be looping around the same table,
>    is this a expected behavior using v8 beta3?

Yes, and for several releases before that too.  You could reduce the
number of loops by increasing vacuum_mem (aka maintenance_work_mem).

One might speculate that you should be vacuuming this table more often,
btw ... when you've got something upwards of 19 million dead rows in
a 300MB table, that seems excessive.

            regards, tom lane