From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Robert Burgholzer <rburghol(at)vt(dot)edu> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: INSERT performance tuning experiences |
Date: | 2013-11-21 15:54:28 |
Message-ID: | CA+U5nMJjG5Y6XtR9f_GVDYcB9H-k1icMJNbA7iZZJ7vVW_i_iQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 21 November 2013 15:27, Robert Burgholzer <rburghol(at)vt(dot)edu> wrote:
> Just thought I would relate this, since it is tangible evidence of what is
> reported in the manuals under WAL tweaking - hope someone finds it useful.
>
> My performance was 76 seconds before tuning versus 7 seconds after tuning.
>
> TASK: Create and populate a table with 30 columns, adding 8,000 rows METHOD:
> Only INSERT statements (accessed via php which does not allow COPY
> statements)
> SYSTEM: Using an 8.3 install (I know, I know)
> WAL CONFIG: changed the default setting of "synchronous_commit = off" to
> "synchronous_commit = on"
Good, that is exactly the numbers I would expect and precisely the
reason we added that feature.
You might find a couple of good features in later releases also...
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Burgholzer | 2013-11-21 16:03:39 | Re: INSERT performance tuning experiences |
Previous Message | Robert Burgholzer | 2013-11-21 15:27:52 | INSERT performance tuning experiences |