X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9C21E11F6081 for ; Tue, 25 Apr 2006 02:00:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 20025-06 for ; Tue, 25 Apr 2006 02:00:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 3155D11F6093 for ; Tue, 25 Apr 2006 02:00:20 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id AD5F456423; Tue, 25 Apr 2006 00:00:19 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 25 Apr 2006 00:00:18 -0500 Date: Tue, 25 Apr 2006 00:00:18 -0500 From: "Jim C. Nasby" To: Tom Lane Cc: "Jonah H. Harris" , John DeSoi , Pgsql Hackers Subject: Re: Google SoC--Idea Request Message-ID: <20060425050017.GC81249@pervasive.com> References: <20060417205455.GP49405@pervasive.com> <44452F9C.8000401@osdl.org> <36e682920604190909p68649a35m1953a7b4262b8852@mail.gmail.com> <20060423214524.GC4775@surnet.cl> <36e682920604231522w96183d0mbedfd7c70d574b58@mail.gmail.com> <20060424165112.GD38186@pervasive.com> <8743.1145932591@sss.pgh.pa.us> <36e682920604241956s2bdd8880q2c479740d893c6fd@mail.gmail.com> <9008.1145934318@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9008.1145934318@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060425:tgl@sss.pgh.pa.us::Am1nsM8CWB2oC6a2:00000000000000000000 0000000000000000000000002mji X-Hashcash: 1:20:060425:jonah.harris@gmail.com::q26riigQr22xMedc:000000000000000 0000000000000000000000000nps X-Hashcash: 1:20:060425:desoi@pgedit.com::SiByy0ELvgb6yhhZ:03D41 X-Hashcash: 1:20:060425:pgsql-hackers@postgresql.org::0ih04YhP/SsWP55v:000000000 0000000000000000000000009UE5 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/902 X-Sequence-Number: 82625 On Mon, Apr 24, 2006 at 11:05:18PM -0400, Tom Lane wrote: > "Jonah H. Harris" writes: > > While the student could do some benchmarking on relatively new > > hardware and make suggestions, I agree with Tom. Having to keep > > support for older platforms doesn't leave much flexibility to change > > the defaults. > > Another point here is that the defaults *are* reasonable for development > and for small installations; the people who are complaining are the ones > who expect to run terabyte databases without any tuning. (I exaggerate > perhaps, but the point is valid.) > > We've talked more than once about offering multiple alternative > starting-point postgresql.conf files to give people an idea of what to > do for small/medium/large installations. MySQL have done that for years > and it doesn't seem that users are unable to cope with the concept. > But doing this is (a) mostly a matter of testing and documenting, not > coding and (b) probably too small for a SoC project anyway. My recollection was that there was opposition to offering multiple config files, but that there was a proposal to make initdb smarter about picking configuration values. Personally, I agree that multiple config files would be fine. Or a really fancy solution would be feeding a config option to initdb and have it generate an appropriate postgresql.conf. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461