[PATCH] Don't bail with legitimate -N/-B options
От | Andreas Kling |
---|---|
Тема | [PATCH] Don't bail with legitimate -N/-B options |
Дата | |
Msg-id | 47B71932.5060104@acgnystrom.se обсуждение исходный текст |
Ответы |
Re: [PATCH] Don't bail with legitimate -N/-B options
Re: [PATCH] Don't bail with legitimate -N/-B options |
Список | pgsql-bugs |
Greetings, Starting PostgreSQL 8.3.0 with the default options used by Gentoo Linux (-N 40 -B 80) causes it to bail with an error message. "the number of buffers (-B) must be at least twice the number of allowed connections (-N) and at least 16" The problem is that NBuffers is actually "max autovacuum connections" + NBuffers. My attached patch fixes this by adding "max autovacuum connections" * 2 to NBuffers before the check. Best regards, Andreas Kling ACG Nyström AB Index: src/backend/postmaster/postmaster.c =================================================================== --- src/backend/postmaster/postmaster.c (revision 30129) +++ src/backend/postmaster/postmaster.c (working copy) @@ -685,6 +685,9 @@ PostmasterMain(int argc, char *argv[]) /* And switch working directory into it */ ChangeToDataDir(); + /* Add buffers to accomodate backends "reserved" for autovacuum */ + NBuffers += autovacuum_max_workers * 2; + /* * Check for invalid combinations of GUC settings. */
В списке pgsql-bugs по дате отправления: