Postgres Pro
Downloads
Home   >   mailing lists

Re: Lock during insert statement - Mailing list pgsql-general

From Jeff Janes
Subject Re: Lock during insert statement
Date
Msg-id CAMkU=1zJhkWWAca8MgXC8ER0cWUg7aWqNF5spnn3nbZ0yfkTbw@mail.gmail.com
Whole thread Raw
In response to Lock during insert statement  (AI Rumman <rummandba@gmail.com>)
Responses Re: Lock during insert statement
List pgsql-general
Tree view
On Wed, May 21, 2014 at 3:14 PM, AI Rumman <rummandba@gmail.com> wrote:
Could any one please tell me why my system is waiting to get lock for an INSERT statement?

2014-05-21 07:52:49.965 PDT [9-1]LOG:  process 31407 acquired ExclusiveLock on extension of relation 429298276 of database 21497 after 3219.963 ms

"on extension of relation" means that it needs to add 8KB to the end of the table.  That it takes so long to obtain that locks suggests you have a some serious IO congestion.

Cheers,

Jeff

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Lock during insert statement
Next
From: AI Rumman
Date:
Subject: Re: Lock during insert statement