INSERT performance tuning experiences

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/