On 21 November 2013 15:27, Robert Burgholzer <rburghol@xxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
