Re: [GENERAL] RowExclusiveLock timeout while autovacuum

2016-08-15 Thread Jeff Janes
On Sun, Aug 14, 2016 at 9:33 PM, zh1029 wrote: > Hi, > We are using PostgreSQL 9.3.11. We are observing DB update failed due to > lock timeout. failure because waiting for RowExclusiveLock. Autovacuum uses > plain vacuum which uses ShareUpdateExclusiveLock. right? > But from Postgres Manual cha

Re: [GENERAL] RowExclusiveLock timeout while autovacuum

2016-08-14 Thread Sameer Kumar
On Mon, Aug 15, 2016 at 12:34 PM zh1029 wrote: > Hi, > We are using PostgreSQL 9.3.11. We are observing DB update failed due to > lock timeout. failure because waiting for RowExclusiveLock. Autovacuum > uses > plain vacuum which uses ShareUpdateExclusiveLock. right? > This I learnt recently,