Vaccum Query

From: PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Vaccum Query
Date: 2017-05-04 12:04:43
Message-ID: CAPgXFMTU0oanoTj3rMf0N1+3pnFRmiNthRpdy-JDzJa=dRBEjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Any Idea what happens when we run standard vacuum (without full) on a table
which has exclusive lock (or alter statement is being processed on that
table).

What happens in this case ? Will vacuum wait for the alter to commit ? If
so, how long ? If not, then what ?

And what actions can be taken to prevent this ?

*Thanks & Regards,Pawan Sharma*
*+91-9899396940*
*Skpye ID: pawanshr.0963*
*Think… before you print(Save Environment)*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-05-04 14:00:05 Re: Column information
Previous Message Durumdara 2017-05-04 11:52:55 pg_stat_activity extra Fields are NULL