From be6668d6eff6a03455b48fa8ce1a397ff5bae788 Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Sat, 26 Feb 2011 23:36:24 +0200 Subject: Increase the default for wal_sender_delay from 200ms to 1s. Now that WAL sender is immediately woken up by transaction commit, there's no need to wake up so aggressively. --- src/backend/replication/walsender.c | 2 +- src/backend/utils/misc/guc.c | 2 +- src/backend/utils/misc/postgresql.conf.sample | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'src') diff --git a/src/backend/replication/walsender.c b/src/backend/replication/walsender.c index eb99246e6d2..49b49d2a181 100644 --- a/src/backend/replication/walsender.c +++ b/src/backend/replication/walsender.c @@ -73,7 +73,7 @@ bool am_walsender = false; /* Am I a walsender process ? */ /* User-settable parameters for walsender */ int max_wal_senders = 0; /* the maximum number of concurrent walsenders */ -int WalSndDelay = 200; /* max sleep time between some actions */ +int WalSndDelay = 1000; /* max sleep time between some actions */ /* * These variables are used similarly to openLogFile/Id/Seg/Off, diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 55cbf757b49..529148a0405 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -1843,7 +1843,7 @@ static struct config_int ConfigureNamesInt[] = GUC_UNIT_MS }, &WalSndDelay, - 200, 1, 10000, NULL, NULL + 1000, 1, 10000, NULL, NULL }, { diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 6726733235b..6bfd0fd87c9 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -188,7 +188,7 @@ #max_wal_senders = 0 # max number of walsender processes # (change requires restart) -#wal_sender_delay = 200ms # walsender cycle time, 1-10000 milliseconds +#wal_sender_delay = 1s # walsender cycle time, 1-10000 milliseconds #wal_keep_segments = 0 # in logfile segments, 16MB each; 0 disables #vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed -- cgit v1.2.3