by Fox128 » Wed Apr 18, 2012 8:49 am
This is what it did for me:
2012/04/18 14:13:41.484 [00005]: [0000232C][PostgresTuner] Tuning local postgres server on port ****
2012/04/18 14:13:41.530 [00046]: [0000232C][PostgresTuner] Profile: 2GB
2012/04/18 14:13:41.530 [00000]: [0000232C][PostgresTuner] Changing 'shared_buffers' from '32MB' to '512MB'
2012/04/18 14:13:41.530 [00000]: [0000232C][PostgresTuner] Changing 'temp_buffers' from '8MB' to '8MB'
2012/04/18 14:13:41.531 [00000]: [0000232C][PostgresTuner] Changing 'work_mem' from '1MB' to '64MB'
2012/04/18 14:13:41.531 [00000]: [0000232C][PostgresTuner] Changing 'wal_buffers' from '64kB' to '512kB'
2012/04/18 14:13:41.531 [00000]: [0000232C][PostgresTuner] Changing 'maintenance_work_mem' from '16MB' to '256MB'
2012/04/18 14:13:41.531 [00000]: [0000232C][PostgresTuner] Changing 'effective_cache_size' from '128MB' to '1GB'
2012/04/18 14:13:41.532 [00000]: [0000232C][PostgresTuner] Changing 'autovacuum' from 'on' to 'on'
2012/04/18 14:13:41.532 [00000]: [0000232C][PostgresTuner] Changing 'checkpoint_segments' from '3' to '32'
2012/04/18 14:13:41.532 [00000]: [0000232C][PostgresTuner] Changing 'random_page_cost' from '4.0' to '3.0'
2012/04/18 14:13:41.532 [00000]: [0000232C][PostgresTuner] Stopping the postgres service
2012/04/18 14:13:42.621 [01089]: [0000232C][PostgresTuner] Starting the postgres service
2012/04/18 14:13:49.836 [07214]: [0000232C][PostgresTuner] Tuning complete