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"
--
Robert W. Burgholzer
'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus
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/
