Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e8DKnqs56533 for ; Wed, 13 Sep 2000 16:49:52 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.0/8.11.0) with ESMTP id e8DKma510666; Wed, 13 Sep 2000 16:48:36 -0400 (EDT) To: Meszaros Attila cc: pgsql-sql@hub.org Subject: Re: Optimizing Multiply Joins ??? In-reply-to: References: Comments: In-reply-to Meszaros Attila message dated "Wed, 13 Sep 2000 21:22:45 +0200" Date: Wed, 13 Sep 2000 16:48:36 -0400 Message-ID: <10663.968878116@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200009/96 Meszaros Attila writes: > Changing this option in a psql session with 'set' has really helped > > But it seems, geqo_rels option is not parsed from the pg_option > file. My mistake. In 7.0 the GEQO options are set in a file "pg_geqo" in the $PGDATA directory. (There should be a prototype file "pg_geqo.sample" there for you to copy and edit.) Peter Eisentraut has cleaned up the option handling for 7.1 so that GEQO options are handled like all the others... regards, tom lane