From 4b113d9cdc8654e3f979497e057c7f9062bfa612 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 5 Feb 2010 23:37:43 +0000 Subject: Document that archive_timeout will force new WAL files even if a single checkpoint has happened, and recommend adjusting checkpoint_timeout to reduce the impact of this. --- src/backend/postmaster/bgwriter.c | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'src/backend/postmaster/bgwriter.c') diff --git a/src/backend/postmaster/bgwriter.c b/src/backend/postmaster/bgwriter.c index b51cceea74d..9a3956a5094 100644 --- a/src/backend/postmaster/bgwriter.c +++ b/src/backend/postmaster/bgwriter.c @@ -38,7 +38,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/postmaster/bgwriter.c,v 1.66 2010/01/15 09:19:02 heikki Exp $ + * $PostgreSQL: pgsql/src/backend/postmaster/bgwriter.c,v 1.67 2010/02/05 23:37:43 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -543,7 +543,10 @@ BackgroundWriterMain(void) /* * CheckArchiveTimeout -- check for archive_timeout and switch xlog files - * if needed + * + * This will switch to a new WAL file and force an archive file write + * if any activity is recorded in the current WAL file, including just + * a single checkpoint record. */ static void CheckArchiveTimeout(void) -- cgit v1.2.3