Re: INSERT performance tuning experiences

On 21 November 2013 15:27, Robert Burgholzer <rburghol@vt.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