Re: [PERFORM] PostgreSQL 9.2.3 performance problem caused Exclusive locks - Mailing list pgsql-general

From Joshua Berkus
Subject Re: [PERFORM] PostgreSQL 9.2.3 performance problem caused Exclusive locks
Date
Msg-id 978553984.25691.1363208698441.JavaMail.root@agliodbs.com
Whole thread Raw
In response to Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks  ("Emre Hasegeli" <emre.hasegeli@tart.com.tr>)
List pgsql-general
Emre,

> > LOG:  process 4793 acquired ExclusiveLock on extension of relation
> > 305605 of database 16396 after 2348.675 ms

The reason you're seeing that message is that you have log_lock_waits turned on.

That message says that some process waited for 2.3 seconds to get a lock for expanding the size of relation
16396/305605,which is most likely an index. This is most likely due to changes in your application, or an increase in
concurrentwrite activity. 

--Josh



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: table spaces
Next
From: Kirk Wythers
Date:
Subject: big un stacking query - help save me from myself