Got it. Thanks. Any special parameter to tune it? Like wal_buffers or shared_buffers?
On Wed, May 21, 2014 at 3:28 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > On Wed, May 21, 2014 at 3:14 PM, AI Rumman <rumman...@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 >
