Re: [PATCH] Don't bail with legitimate -N/-B options

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Andreas Kling <andreas(dot)kling(at)acgnystrom(dot)se>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [PATCH] Don't bail with legitimate -N/-B options
Date: 2008-03-10 14:05:46
Message-ID: 200803101405.m2AE5k604260@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


FYI, the restriction that -B must be larger than -N will be removed in 8.4.

---------------------------------------------------------------------------

Andreas Kling wrote:
> 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

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-03-10 14:12:28 Re: BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'
Previous Message Username_PalmTreesNSand 2008-03-10 13:20:09 BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'