Mason Hale <masonhale@gmail.com> writes:
> I'm seeing some odd warning in my postgres (8.3.6) logs.
> 2009-06-01 20:01:59 UTC (10.11.199.136)LOG: process 7070 still
> waiting for ExclusiveLock on extension of relation 43911 of database
> 43623 after 1001.240 ms
Have you looked up the OIDs to see exactly which tables or indexes are
being complained of?
> Yet I'm surprised this is taking > 1 full second with some frequency.
How busy is the database overall --- is this much more than the normal
transaction execution time?
regards, tom lane