PostgreSQL CVS Testing at OSDL
Here are
instructions
for how to run your own tests in OSDL's automated test framework (STP).
Results
Test Parameters
- 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.
Test Parameters
- 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
Results
Test Parameters
- 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
Questions?