Re: [GENERAL] Vaccum Query

2017-05-05 Thread Vik Fearing
On 05/04/2017 02:04 PM, PAWAN SHARMA wrote: > 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 ? > Yes

[GENERAL] Vaccum Query

2017-05-04 Thread PAWAN SHARMA
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