Database Test 3 Results

Software VersionHardware ConfigurationWorkload Parameters
Operating System: 3.0.101-0.15-default16 CPUs @ 1300.000Scale Factor: 10
Database Server: PostgreSQL 9.2.9 Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHzStreams: 4
264524424 KB RAM

Metrics

Runtime Parameters
Composite:3302
Load Time: 15.60 Minutes / .26 Hours

Load Test Details

 -c shared_buffers=8GB -c work_mem=1GB -c maintenance_work_mem=4GB -c checkpoint_segments=300 -c checkpoint_timeout=60min -c effective_cache_size=200GB -c default_statistics_target=1000
Query Processing Power: 2175

Power Test Details

 -c shared_buffers=8GB -c work_mem=1GB -c maintenance_work_mem=4GB -c checkpoint_segments=300 -c checkpoint_timeout=60min -c effective_cache_size=200GB -c default_statistics_target=1000
Throughput Numerical Quantity: 5013.17

Throughput Test Details

 -c shared_buffers=8GB -c work_mem=1GB -c maintenance_work_mem=4GB -c checkpoint_segments=300 -c checkpoint_timeout=60min -c effective_cache_size=200GB -c default_statistics_target=1000

Query Times

(Click to view full size.)

CSV Version