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-22 02:35:54
Message-ID: CAMkU=1z2dGJQWhnEfizWBQh2uSax634hnH3vUKYts0QT19FKoA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, May 21, 2014, AI Rumman <rummandba(at)gmail(dot)com> 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 (sar, vmstat)? What is the expected theoretical write throughput
of your RAID?

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Van Dyk 2014-05-22 02:48:37 Re: Do foreign key triggers get ran even if the key's value doesn't change?
Previous Message David G Johnston 2014-05-21 23:50:05 Re: Question regarding DEALLOCATE pdo_stmt_00000001