X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 695E9B439DE for ; Thu, 3 Jul 2003 23:25:43 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 28069-10 for ; Thu, 3 Jul 2003 20:25:32 -0300 (ADT) Received: from perrin.int.nxad.com (internal.ext.nxad.com [69.1.70.251]) by svr1.postgresql.org (Postfix) with ESMTP id B17CEB439F3 for ; Thu, 3 Jul 2003 20:25:32 -0300 (ADT) Received: by perrin.int.nxad.com (Postfix, from userid 1001) id 8093320F00; Thu, 3 Jul 2003 16:25:35 -0700 (PDT) Date: Thu, 3 Jul 2003 16:25:35 -0700 From: Sean Chittenden To: Brian Hirt Cc: "scott.marlowe" , pgsql-performance@postgresql.org Subject: Re: Moving postgresql.conf tunables into 2003... Message-ID: <20030703232535.GT72567@perrin.int.nxad.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-PGP-Key: finger seanc@FreeBSD.org X-PGP-Fingerprint: 3849 3760 1AFE 7B17 11A0 83A6 DD99 E31F BC84 B341 X-Web-Homepage: http://sean.chittenden.org/ User-Agent: Mutt/1.5.4i X-Archive-Number: 200307/38 X-Sequence-Number: 2331 > I'm curious how many of the configuration values can be determined > automatically, or with the help of some script. It seem like there > could be some perl script in contrib that could help figure this out. > Possibly you are asked a bunch of questions and then the values are > computed based on that. Something like: > > How many tables will the system have? > How much memory will be available to the postmaster? > How many backends will there typically be? > What is the avg seek time of the drive? > What's the transfer rate of the drive? > > Seems to me that a lot of reasonable default values can be figure out > from these basic questions. FSM settings, Sort Mem, Random Page Cost, > Effective Cache Size, Shared Memor, etc, etc. Someone was working on a thing called pg_autotune or some such program that'd do exactly what you're thinking of. http://archives.postgresql.org/pgsql-performance/2002-10/msg00101.php http://gborg.postgresql.org/project/pgautotune/projdisplay.php -- Sean Chittenden