From d9384a4b7334ba755db88160fb96cd33725bd6d3 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 9 Mar 2008 04:56:28 +0000 Subject: Remove postmaster.c's check that NBuffers is at least twice MaxBackends. With the addition of multiple autovacuum workers, our choices were to delete the check, document the interaction with autovacuum_max_workers, or complicate the check to try to hide that interaction. Since this restriction has never been adequate to ensure backends can't run out of pinnable buffers, it doesn't really have enough excuse to live to justify the second or third choices. Per discussion of a complaint from Andreas Kling (see also bug #3888). This commit also removes several documentation references to this restriction, but I'm not sure I got them all. --- src/backend/utils/misc/postgresql.conf.sample | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'src/backend/utils/misc/postgresql.conf.sample') diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 258a7d1a4f5..d3604c2d5c0 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -60,8 +60,7 @@ #port = 5432 # (change requires restart) #max_connections = 100 # (change requires restart) # Note: Increasing max_connections costs ~400 bytes of shared memory per -# connection slot, plus lock space (see max_locks_per_transaction). You might -# also need to raise shared_buffers to support more connections. +# connection slot, plus lock space (see max_locks_per_transaction). #superuser_reserved_connections = 3 # (change requires restart) #unix_socket_directory = '' # (change requires restart) #unix_socket_group = '' # (change requires restart) @@ -104,7 +103,7 @@ # - Memory - -#shared_buffers = 32MB # min 128kB or max_connections*16kB +#shared_buffers = 32MB # min 128kB # (change requires restart) #temp_buffers = 8MB # min 800kB #max_prepared_transactions = 5 # can be 0 or more -- cgit v1.2.3