X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DDE9AD1B502 for ; Mon, 3 Nov 2003 18:42:33 +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 16034-04 for ; Mon, 3 Nov 2003 14:42:03 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 0371BD1B53E for ; Mon, 3 Nov 2003 14:42:02 -0400 (AST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3863359; Mon, 03 Nov 2003 10:42:44 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Lee Hughes" , Subject: Re: join_collapse_limit, from_collapse_limit options missing Date: Mon, 3 Nov 2003 10:41:04 -0800 User-Agent: KMail/1.4.3 References: <70AA9BD4C82E76418F730DF1411A624F06DF12@meta01.owens.int> In-Reply-To: <70AA9BD4C82E76418F730DF1411A624F06DF12@meta01.owens.int> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200311031041.04816.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/7 X-Sequence-Number: 4567 Lee, > Hi, I'm trying to set these two options to tune performance but both > return 'not a valid option name'. Dumping the pg_settings table confirms > that they are missing. I'm using the PostgreSQL packages included with > RedHat 9 (7.3.2) and Mandrake 9.2 Beta (7.3.4). Do I need to install the > full tarball to get these options? Any help greatly appreciated. If you're working from the documentation on General Bits, please notice that both of those options are marked as "new for 7.4". -- Josh Berkus Aglio Database Solutions San Francisco