X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0421AD1D989 for ; Mon, 24 Nov 2003 11:26:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43333-09 for ; Mon, 24 Nov 2003 07:25:52 -0400 (AST) Received: from easily.co.uk (unknown [213.161.76.90]) by svr1.postgresql.org (Postfix) with ESMTP id F270CD1D8DA for ; Mon, 24 Nov 2003 07:25:48 -0400 (AST) Received: from [80.3.250.23] (HELO hare) by easily.co.uk (CommuniGate Pro SMTP 4.1.3) with SMTP id 35717045; Mon, 24 Nov 2003 11:25:31 +0000 Message-ID: <000c01c3b27d$91b4fec0$0300a8c0@hare> From: "Nick Barr" To: "Josh Berkus" , References: <3FBF4EF3.6090507@chuckie.co.uk> <200311220919.23695.josh@agliodbs.com> Subject: Re: pg_autoconfig.pl Date: Mon, 24 Nov 2003 11:24:47 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/206 X-Sequence-Number: 4766 ----- Original Message ----- From: "Josh Berkus" To: "Nick Barr" ; Sent: Saturday, November 22, 2003 5:19 PM Subject: Re: pg_autoconfig.pl > Nick, > > > Josh have you managed to put together the rest of the calculations yet? > > Given that I spent most of November working on the PR for the 7.4 release, > I've just started to think about it. As you can see, I'm thinking about > dovetailing pg_avd and pg_autoconf. > > The difficult thing is to figure out settings for "bad" hardware setups. Like > a 5GB database on a PIII500 + 256mb running 4 other pieces of major software > (I've acctually seen this). Or a 500/minute OLTP database on a machine > with 1 fixed disk. > > All the variables are going into a hash array, right? Yep that rights.$sys is the array name. And there are loads of different keys for the hash. I will try and get a listing out of the script sometime. Nick