Autovacuum holding exclusive lock on table

From: "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Autovacuum holding exclusive lock on table
Date: 2018-05-08 13:38:19
Message-ID: a384a17edef5446ea5847b8387553cfd@USFKL11XG20CN01.mercer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-05-08 14:18:08 Re: cursor empty
Previous Message Adrian Klaver 2018-05-08 13:36:08 Re: cursor empty