BUG #6741: ExclusiveLock on extension of relation
The following bug has been logged on the website:
Bug reference: 6741
Logged by: Peter
Email address: ryseq@hotmail.com
PostgreSQL version: 9.1.3
Operating system: Linux
Description:
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
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