Waiting on ExclusiveLock on extension

From: Andomar <andomar(at)aule(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Waiting on ExclusiveLock on extension
Date: 2015-04-16 20:24:46
Message-ID: 55301A8E.8040005@aule.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

After upgrading our database from 9.3.5 to 9.4.1 last night, the server
suffers from high CPU spikes. During these spikes, there are a lot of
these messages in the logs:

process X still waiting for ExclusiveLock on extension of relation
Y of database Z after 1036.234 ms

And:

process X acquired ExclusiveLock on extension of relation Y of
database Z after 2788.050 ms

What looks suspicious is that there are sometimes several "acquired"
messages for the exact same relation number in the exact same millisecond.

a) I'm assuming "extension" means growing the physical diskspace used by
a table-- is that correct?
b) How can you find the name of the relation being extended? based on
the relation number.
c) Why would Postgres grow a table twice in the same millisecond? Could
it be an index with a high fill factor?

Any suggestions on how to approach this issue are welcome.

Thanks for your time,
Andomar

P.S. The upgrade was done with pg_dump. So the database was converted
to SQL and then imported into 9.4.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-04-16 20:36:20 Re: PL\pgSQL 'ERROR: invalid input syntax for type oid:' [PostgreSQL 9.3.6 and 9.4]
Previous Message Adrian Klaver 2015-04-16 20:10:11 Re: Error using DAO with the ODBC driver S1000: positioned_load in pos_newload failed