Search Postgresql Archives

Re: Corrupt index stopping autovacuum system wide

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

 



Peter Geoghegan <pg@xxxxxxx> writes:
> On Wed, Jul 17, 2019 at 8:54 AM Aaron Pelz <aaronepelz@xxxxxxxxx> wrote:
>> To me it looks like a *single* corrupt index held up autovacuums across our entire server, even other in other databases on the same server. Am I interpreting this correctly?

> Yes -- that is correct.

It looks that way, but how would a broken non-shared index have held up
autovacuuming in other databases?  Maybe, as this one's xmin horizon
got further and further behind, the launcher eventually stopped
considering launching workers into any other databases?  That seems
like a bad thing; it's postponing work that will need to be done
eventually.

			regards, tom lane






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux