PostgreSQL CVS Testing at OSDL

Here are instructions for how to run your own tests in OSDL's automated test framework (STP).

DBT-2 (OLTP)

Scale Factor : 200 - theoretical max metric is 2400 notpm.
Database Parameters = -c shared_buffers=15000 -c checkpoint_segments=1024 -c checkpoint_timeout=3600 -c stats_start_collector=true -c stats_command_string=true -c stats_block_level=true -c stats_row_level=true -c stats_reset_on_server_start=true
Linux Boot Parameters : profile=2 elevator=deadline
Linux Runtime Parameters : kernel.shmmax=2000000000 kernel.shmall=2000000000 vm.dirty_writeback_centisecs=0

Old Results - These parameters are no longer used.

Scale Factor : 150 - theoretical max metric is 1800 notpm.
Database Parameters : -c shared_buffers=15000 -c effective_cache_size=220000 -c work_mem=1024 -c max_fsm_pages=1000000 -c checkpoint_segments=256 -c stats_start_collector=true -c stats_command_string=true -c stats_block_level=true -c stats_row_level=true -c stats_reset_on_server_start=true
Linux Boot Parameters : profile=2 elevator=deadline
Linux Runtime Parameters : kernel.shmmax=2000000000 kernel.shmall=2000000000 vm.dirty_writeback_centisecs=0

Scale Factor : 1 GB
Load Phase Database Parameters : -c shared_buffers=15000 -c checkpoint_segments=1024 -c checkpoint_timeout=3600 -c stats_start_collector=true -c stats_command_string=true -c stats_block_level=true -c stats_row_level=true -c stats_reset_on_server_start=true
Power Phase Database Parameters : -c shared_buffers=15000 -c checkpoint_segments=1024 -c checkpoint_timeout=3600 -c stats_start_collector=true -c stats_command_string=true -c stats_block_level=true -c stats_row_level=true -c stats_reset_on_server_start=true
Throughput Phase Database Parameters : -c shared_buffers=15000 -c checkpoint_segments=1024 -c checkpoint_timeout=3600 -c stats_start_collector=true -c stats_command_string=true -c stats_block_level=true -c stats_row_level=true -c stats_reset_on_server_start=true
Linux Boot Parameters : profile=2 elevator=deadline
Linux Runtime Parameters : kernel.shmmax=2000000000 kernel.shmall=2000000000 vm.dirty_writeback_centisecs=0