Re: Lock during insert statement

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Lock during insert statement
Date: 2014-05-21 22:28:28
Message-ID: CAMkU=1zJhkWWAca8MgXC8ER0cWUg7aWqNF5spnn3nbZ0yfkTbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 21, 2014 at 3:14 PM, AI Rumman <rummandba(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2014-05-21 23:42:15 Re: Lock during insert statement
Previous Message AI Rumman 2014-05-21 22:14:38 Lock during insert statement