| From: | desmodemone <desmodemone(at)gmail(dot)com> |
|---|---|
| To: | Skarsol <skarsol(at)gmail(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: WAL + SSD = slow inserts? |
| Date: | 2013-12-05 15:06:35 |
| Message-ID: | CAEs9oFk4bFCA7cS=Q-EkN6joMbqwrGGpL8v8dU8d9S1rpA0HGA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmail(dot)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?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Skarsol | 2013-12-05 15:16:35 | Re: WAL + SSD = slow inserts? |
| Previous Message | Skarsol | 2013-12-05 15:01:54 | WAL + SSD = slow inserts? |