Re: Optimizing Multiply Joins ??? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Optimizing Multiply Joins ???
Date
Msg-id 10663.968878116@sss.pgh.pa.us
Whole thread Raw
In response to Re: Optimizing Multiply Joins ???  (Meszaros Attila <tilla@draconis.elte.hu>)
List pgsql-sql
Meszaros Attila <tilla@draconis.elte.hu> 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


pgsql-sql by date:

Previous
From: Meszaros Attila
Date:
Subject: Re: Optimizing Multiply Joins ???
Next
From: Bernie Huang
Date:
Subject: Group by within table joins