Re: waiting for ExclusiveLock on extension of relation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mason Hale <masonhale(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: waiting for ExclusiveLock on extension of relation
Date: 2009-06-01 23:16:32
Message-ID: 26716.1243898192@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mason Hale <masonhale(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig de Stigter 2009-06-01 23:57:24 Re: pg_stats.avg_width differs by a factor of 4 on different machines
Previous Message Mason Hale 2009-06-01 23:13:31 waiting for ExclusiveLock on extension of relation