Database Test 3 Results

Software VersionHardware ConfigurationWorkload Parameters
Operating System: 3.10.0-229.el7.x86_644 CPUs @ 2494.080Scale Factor: 100
Database Server: PostgreSQL 9.5alpha1 (Postgres-XL 9.5alpha1) Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHzStreams: 2
30987820 KB RAM
datanodes: 8

Metrics

Runtime Parameters
Composite:5285
Load Time: 43.06 Minutes / .71 Hours

Load Test Details

-c shared_buffers=8GB -c maintenance_work_mem=8GB -c log_checkpoints=on -c log_line_prefix='%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h ' -c log_lock_waits=on -c log_temp_files=0 -c effective_cache_size=20GB -c work_mem=1GB -c max_prepared_transactions=100 -c default_statistics_target=10000 -c max_connections=300 -c max_wal_size=128GB
Query Processing Power: 7046

Power Test Details

-c shared_buffers=8GB -c work_mem=512MB -c default_statistics_target=1000 -c log_checkpoints=on -c log_line_prefix='%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h ' -c log_lock_waits=on -c log_temp_files=0 -c effective_cache_size=20GB -c max_connections=1000 -c shared_queue_size=8192 -c max_prepared_transactions=100 -c statement_timeout=2000s
Throughput Numerical Quantity: 3964.51

Throughput Test Details

-c shared_buffers=8GB -c work_mem=512MB -c default_statistics_target=1000 -c log_checkpoints=on -c log_line_prefix='%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h ' -c log_lock_waits=on -c log_temp_files=0 -c effective_cache_size=20GB -c max_prepared_transactions=100 -c max_connections=1000 -c shared_queue_size=8192 -c statement_timeout=1000s

Query Times

(Click to view full size.)

CSV Version