Unix Technical Forum

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

This is a discussion on Re: [PATCH] Don't bail with legitimate -N/-B options within the pgsql Bugs forums, part of the PostgreSQL category; --> FYI, the restriction that -B must be larger than -N will be removed in 8.4. --------------------------------------------------------------------------- Andreas Kling wrote: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 11:15 AM
Bruce Momjian
 
Posts: n/a
Default Re: [PATCH] Don't bail with legitimate -N/-B options


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@postgresql.org so that your
> message can get through to the mailing list cleanly


--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:42 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com