Autovacuum holding exclusive lock on table - Mailing list pgsql-general

From Kumar, Virendra
Subject Autovacuum holding exclusive lock on table
Date
Msg-id a384a17edef5446ea5847b8387553cfd@USFKL11XG20CN01.mercer.com
Whole thread Raw
List pgsql-general

Hi,

 

I have as scenario where one of our developer created a table loaded huge amount of data and since then auto vacuum is not letting us do alter table for disabling it, even truncate and drop are locked. Is there anything we can do to prevent this and disable autovacuum at least.

 

 

Regards,

Virendra




This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: cursor empty
Next
From: "David G. Johnston"
Date:
Subject: Re: cursor empty