Re: Lock during insert statement

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Wednesday, May 21, 2014, AI Rumman <rummandba@xxxxxxxxx> 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