Mason Hale <masonhale@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
