gleeco <gleeco@gmail.com> writes:
> hello - i've a long-running manual vacuum on a big size table. It's many
> TB db that has some toast. What is odd is that it keeps looping back on
> the same toast / index, eg.
It's not looping ... it's filling up your maintenance_work_mem (which is
evidently set to 1GB) with dead TIDs and then pausing to do a cycle of
index cleaning. You have evidently let that table get, um, severely
bloated. Was autovacuum off?
regards, tom lane