| From: | Jeff Janes <jeff(dot)janes(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 17:56:56 |
| Message-ID: | CAMkU=1zwM+p_9-Gi_rBXHYfMtEuiGnDYsjhQWq+yiks4b4AbtA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Dec 5, 2013 at 7:01 AM, Skarsol <skarsol(at)gmail(dot)com> wrote:
> 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?
>
What are you inserting? At 0.3 seconds per, I'm guessing this is not just
a simple single-row insert statement.
Are you IO bound or CPU bound?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2013-12-05 18:08:14 | Re: WAL + SSD = slow inserts? |
| Previous Message | David Johnston | 2013-12-05 16:14:39 | Re: One huge db vs many small dbs |