Re: vacuum toast loop?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



gleeco <gleeco@xxxxxxxxx> 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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux