Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Vaccum Query - Mailing list pgsql-general

From PAWAN SHARMA
Subject [GENERAL] Vaccum Query
Date
Msg-id CAPgXFMTU0oanoTj3rMf0N1+3pnFRmiNthRpdy-JDzJa=dRBEjQ@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Vaccum Query  (Vik Fearing <vik.fearing@2ndquadrant.com>)
List pgsql-general
Tree view
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)


pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: [GENERAL] pg_stat_activity extra Fields are NULL
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Column information