> 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
pgsql-bugs by date
|Next:||From: Chan Pham||Date: 2012-07-17 18:53:55|
|Subject: Re: log_truncate_on_rotation=on is not truncating|
|Previous:||From: ryseq||Date: 2012-07-17 15:04:10|
|Subject: BUG #6741: ExclusiveLock on extension of relation |