X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D4978474E5C for ; Tue, 11 Feb 2003 16:53:42 -0500 (EST) Received: from utility.wgcr.org (unknown [206.74.232.205]) by postgresql.org (Postfix) with ESMTP id 44DB4474E53 for ; Tue, 11 Feb 2003 16:53:42 -0500 (EST) Received: from utility.wgcr.org ([10.1.0.2]) by utility.wgcr.org (8.12.5/8.12.5) with ESMTP id h1BLrh6q005284; Tue, 11 Feb 2003 16:53:43 -0500 Received: from ([10.1.2.238]) by utility.wgcr.org (MailMonitor for SMTP v1.2.1 ) ; Tue, 11 Feb 2003 16:53:43 -0500 (EST) Content-Type: text/plain; charset="utf-8" From: Lamar Owen To: Robert Treat , PostgresSQL Hackers Mailing List Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy] Date: Tue, 11 Feb 2003 16:53:39 -0500 User-Agent: KMail/1.4.3 References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <3E492E06.2030702@postgresql.org> <1044986625.12931.27.camel@camel> In-Reply-To: <1044986625.12931.27.camel@camel> MIME-Version: 1.0 Message-Id: <200302111653.39763.lamar.owen@wgcr.org> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/426 X-Sequence-Number: 35368 On Tuesday 11 February 2003 13:03, Robert Treat wrote: > On Tue, 2003-02-11 at 12:08, Justin Clift wrote: > > b) Said benchmarking person knows very little about PostgreSQL, so they > > install the RPM's, packages, or whatever, and "it works". Then they run > > whatever benchmark they've downloaded, or designed, or whatever > Out of curiosity, how feasible is it for the rpm/package/deb/exe > maintainers to modify their supplied postgresql.conf settings when > building said distribution? AFAIK the minimum default SHHMAX setting on > Red Hat 8.0 is 32MB, seems like bumping shared buffers to work with that > amount would be acceptable inside the 8.0 rpm's. Yes, this is easy to do. But what is a sane default? I can patch any file= =20 I'd like to, but my preference is to patch as little as possible, as I'm=20 trying to be generic here. I can't assume Red Hat 8 in the source RPM, and= =20 my binaries are to be preferred only if the distributor doesn't have update= d=20 ones. --=20 Lamar Owen WGCR Internet Radio 1 Peter 4:11