Обсуждение: 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:=20=20=20=20=20=20=20=20

i have  been getting the  message below in the  logs  whats causes these
statements to appear in the logs?
=20
  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