On Thu, 27 Oct 2016 10:44:03 -0400
Tom Lane wrote:
> > I'm asking for cases of large tables where autovacuum frequently gets
> > interrupted. I'm trying to understand if the partial runs are at least
> > making _some_ progress so the next vacuum has less to do, or if this is
> > a serious problem
Bill Moran writes:
> Does interrupting a VACUUM (not FULL) rollback all the work it has done
> so far, or is the work done on a page by page basis such that at least
> some of the pages in the table have been vacuumed?
Depends on how big the table is, how many dead tuples there are, and
what main
Very specific question:
Does interrupting a VACUUM (not FULL) rollback all the work it has done
so far, or is the work done on a page by page basis such that at least
some of the pages in the table have been vacuumed?
I'm asking for cases of large tables where autovacuum frequently gets
interrupt
