On Wednesday, May 21, 2014, AI Rumman wrote:
> Got it.
> Thanks.
> Any special parameter to tune it? Like wal_buffers or shared_buffers?
>
Possible but unlikely. You probably just need better hardware (or more
patience). How fast is the database growing? How much is actually being
written (sa
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 wrote:
> On Wed, May 21, 2014 at 3:14 PM, AI Rumman wrote:
>
>> Could any one please tell me why my system is waiting to get lock for an
>> INSERT statement?
>>
>>
On Wed, May 21, 2014 at 3:14 PM, AI Rumman 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
