Re: hung backends stuck in spinlock heavy endless loop

Merlin Moncure <mmoncure@gmail.com> writes:
> There were seven process with that backtrace exact backtrace (except
> that randomly they are sleeping in the spinloop).   Something else
> interesting: autovacuum has been running all night as well.  Unlike
> the other process however, cpu utilization does not register on top.
> I backtraced them as well.  They are not identical.  One of them looks
> like this:

What are the autovac processes doing (according to pg_stat_activity)?
        regards, tom lane