[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 по дате отправления: