Re: BUG #6741: ExclusiveLock on extension of relation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ryseq(at)hotmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6741: ExclusiveLock on extension of relation
Date: 2012-07-17 17:09:24
Message-ID: 12878.1342544964@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

ryseq(at)hotmail(dot)com writes:
> i have been getting the message below in the logs whats causes these
> statements to appear in the logs?

> process 11812 acquired ExclusiveLock on extension of relation 60777 of
> database 16387 after 1392.303 ms
> LOG: process 24079 still waiting for ExclusiveLock on extension of relation
> 60777 of database 16387 after 1000.183 ms

Apparently you've got log_lock_waits turned on.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Chan Pham 2012-07-17 18:53:55 Re: log_truncate_on_rotation=on is not truncating
Previous Message ryseq 2012-07-17 15:04:10 BUG #6741: ExclusiveLock on extension of relation