Re: BUG #6741: ExclusiveLock on extension of relation - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6741: ExclusiveLock on extension of relation
Date
Msg-id 12878.1342544964@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6741: ExclusiveLock on extension of relation  (ryseq@hotmail.com)
List pgsql-bugs
ryseq@hotmail.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

pgsql-bugs by date:

Previous
From: ryseq@hotmail.com
Date:
Subject: BUG #6741: ExclusiveLock on extension of relation
Next
From: Chan Pham
Date:
Subject: Re: log_truncate_on_rotation=on is not truncating