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=1z2dGJQWhnEfizWBQh2uSax634hnH3vUKYts0QT19FKoA@mail.gmail.com
Whole thread Raw
In response to Re: Lock during insert statement  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Tree view
On Wednesday, May 21, 2014, AI Rumman <rummandba@gmail.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

pgsql-general by date:

Previous
From: David G Johnston
Date:
Subject: Re: Question regarding DEALLOCATE pdo_stmt_00000001
Next
From: Joe Van Dyk
Date:
Subject: Re: Do foreign key triggers get ran even if the key's value doesn't change?