From: | Robert Burgholzer <rburghol(at)vt(dot)edu> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | INSERT performance tuning experiences |
Date: | 2013-11-21 15:27:52 |
Message-ID: | CACT-NG+emD1mG4LUToK=eGe_5aZ12NKC7PwyWSwPZo0t47c20g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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"
http://www.postgresql.org/docs/current/interactive/runtime-config-wal.html.
--
--
Robert W. Burgholzer
'Making the simple complicated is commonplace; making the complicated
simple, awesomely simple, that's creativity.' - Charles Mingus
Athletics: http://athleticalgorithm.wordpress.com/
Science: http://robertwb.wordpress.com/
Wine: http://reesvineyard.wordpress.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2013-11-21 15:54:28 | Re: INSERT performance tuning experiences |
Previous Message | Payal Singh | 2013-11-21 15:09:43 | Re: Archive fails due to missing backup file |