Re: WAL + SSD = slow inserts? - Mailing list pgsql-performance

From desmodemone
Subject Re: WAL + SSD = slow inserts?
Date
Msg-id CAEs9oFk4bFCA7cS=Q-EkN6joMbqwrGGpL8v8dU8d9S1rpA0HGA@mail.gmail.com
Whole thread Raw
In response to WAL + SSD = slow inserts?  (Skarsol <skarsol@gmail.com>)
Responses Re: WAL + SSD = slow inserts?
List pgsql-performance
Hello,
             could you please post the postgresql version, the postgresql.conf, the operative system used, the kernel version and the filesystem used ?

Thank you


2013/12/5 Skarsol <skarsol@gmail.com>
I'm trying to increase the speed of inserts in a database that is on a not super fast storage system. I have installed a pair of SSDs and placed pg_xlog on them but am still getting inserts that take up to a second to complete, with .3 seconds being about average. Iostat doesn't show the SSDs stressed at all, and changing synchronous_commit doesn't seem to affect it one way or the other. Where would I look next for what could be causing the delay?

pgsql-performance by date:

Previous
From: Skarsol
Date:
Subject: WAL + SSD = slow inserts?
Next
From: Skarsol
Date:
Subject: Re: WAL + SSD = slow inserts?