Another apology: My pg_version is 9.3 and here are more up to date png's.
On 26 November 2014 at 15:34, Johann Spies <johann.sp...@gmail.com> wrote: > Hello Greame, > > It's probably helpful if everyone sharing this information can post their >> measurement process / settings and the results as completely as possible, >> for comparison and reference. >> > > Apologies. I have only changed one parameter in postgresql.conf for the > tests and that was shared_buffers: > > shared_buffers = 32GB # min 128k > shared_preload_libraries = 'auto_explain' # (change requires > restart) > vacuum_cost_delay = 5 # 0-100 milliseconds > wal_sync_method = open_sync # the default is the first option > wal_buffers = -1 # min 32kB, -1 sets based > on shared_buffers > checkpoint_completion_target = 0.9 # checkpoint target > duration, 0.0 - 1.0 > checkpoint_warning = 30s # 0 disables > default_statistics_target = 100 # range 1-10000 > log_line_prefix = '%t ' # special values: > log_statement = 'all' # none, ddl, mod, all > log_timezone = 'localtime' > autovacuum_vacuum_scale_factor = 0.1 # fraction of table size > before vacuum > autovacuum_vacuum_cost_delay = 5ms # default vacuum cost > delay for > datestyle = 'iso, dmy' > timezone = 'localtime' > lc_messages = 'en_ZA.UTF-8' # locale for > system error message > lc_monetary = 'en_ZA.UTF-8' # locale for > monetary formatting > lc_numeric = 'en_ZA.UTF-8' # locale for > number formatting > lc_time = 'en_ZA.UTF-8' # locale for time > formatting > default_text_search_config = 'pg_catalog.english' > auto_explain.log_min_duration = '6s' # Gregory Smith page 180 > effective_cache_size = 512GB # pgtune wizard 2014-09-25 > work_mem = 4608MB # pgtune wizard 2014-09-25 > checkpoint_segments = 16 # pgtune wizard 2014-09-25 > max_connections = 80 # pgtune wizard 2014-09-25 > > And pgbench-tools - the default configuration: > > BASEDIR=`pwd` > PGBENCHBIN=`which pgbench` > TESTDIR="tests" > SKIPINIT=0 > TABBED=0 > OSDATA=1 > TESTHOST=localhost > TESTUSER=`whoami` > TESTPORT=5432 > TESTDB=pgbench > RESULTHOST="$TESTHOST" > RESULTUSER="$TESTUSER" > RESULTPORT="$TESTPORT" > RESULTDB=results > MAX_WORKERS="" > SCRIPT="select.sql" > SCALES="1 10 100 1000" > SETCLIENTS="1 2 4 8 16 32" > SETTIMES=3 > RUNTIME=60 > TOTTRANS="" > SETRATES="" > > > The server: > > # See Gregory Smith: High Performans Postgresql 9.0 pages 81,82 for the > next lines > vm.swappiness=0 > vm.overcommit_memory=2 > vm.dirty_ratio = 2 > vm.dirty_background_ratio=1 > # Maximum shared segment size in bytes > kernel.shmmax = 406622322688 > # Maximum number of shared memory segments in pages > kernel.shmall = 99273028 > > $ free > total used free shared buffers cached > Mem: 794184164 792406416 1777748 0 123676 788079892 > -/+ buffers/cache: 4202848 789981316 > Swap: 7906300 0 7906300 > > I have attached the resulting graphs. > > Regards > Johann > > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3) > -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance