Re: vacuum toast loop?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gleeco <gleeco(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum toast loop?
Date: 2017-01-11 22:46:52
Message-ID: 21880.1484174812@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

gleeco <gleeco(at)gmail(dot)com> writes:
> Main question now: is there actually new work getting done when it
> repeats? ie. am i making progress?

Yes, I would expect so, especially since the tuple counts are varying
a bit. If it were always exactly the same tuple count then there might
be some reason to worry. If you weren't seeing any verbose output at
all, there would be much more reason to worry.

(FWIW, as of 9.6 or thereabouts there's some support for vacuum progress
tracking via pg_stat_activity. Won't help you now, but it's out there.)

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jan Harasym 2017-01-16 08:04:14 Re: Lock Error
Previous Message gleeco 2017-01-11 19:30:39 Re: vacuum toast loop?