Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E9AAA9FBE2E for ; Fri, 4 May 2007 14:22:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17678-03 for ; Fri, 4 May 2007 14:22:33 -0300 (ADT) X-Greylist: delayed 00:42:17.572871 by SQLgrey-1.7.4 Received: from mail.laliluna.com (mail.laliluna.com [85.190.26.55]) by postgresql.org (Postfix) with ESMTP id 434AD9FBDB3 for ; Fri, 4 May 2007 14:22:33 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.laliluna.com (Postfix) with ESMTP id 046535F8097 for ; Fri, 4 May 2007 19:22:32 +0200 (CEST) Received: from mail.laliluna.com ([85.190.26.55]) by localhost (asterix.laliluna.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id c+TZKic0Qcw8 for ; Fri, 4 May 2007 19:22:31 +0200 (CEST) Received: from [192.168.1.100] (p54b2c87c.dip.t-dialin.net [84.178.200.124]) by mail.laliluna.com (Postfix) with ESMTP id C62F05F8094 for ; Fri, 4 May 2007 19:22:31 +0200 (CEST) Message-ID: <463B6BD7.7010308@laliluna.de> Date: Fri, 04 May 2007 19:22:31 +0200 From: Sebastian Hennebrueder User-Agent: Thunderbird 1.5.0.10 (X11/20070306) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning References: <463B61ED.20409@laliluna.de> <200705041011.42313.josh@agliodbs.com> In-Reply-To: <200705041011.42313.josh@agliodbs.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/52 X-Sequence-Number: 24442 Josh Berkus schrieb: > Sebastian, > > >> Before inventing a hyper tool, we might consider to provide 3-5 example >> szenarios for common hardware configurations. This consumes less time >> and be discussed and defined in a couple of days. This is of course not >> the correct option for a brandnew 20 spindle Sata 10.000 Raid 10 system >> but these are probably not the target for default configurations. >> > > That's been suggested a number of times, but some GUCs are really tied to the > *exact* amount of RAM you have available. So I've never seen how "example > configurations" could help. > > I would define the szenario as 256 MB freely available for PostgresQL => setting x can be of size ...