Skip site navigation (1) Skip section navigation (2)

Re: Optimizing Multiply Joins ???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Meszaros Attila <tilla(at)draconis(dot)elte(dot)hu>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: Optimizing Multiply Joins ???
Date: 2000-09-13 20:48:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Meszaros Attila <tilla(at)draconis(dot)elte(dot)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

In response to

pgsql-sql by date

Next:From: Bernie HuangDate: 2000-09-13 22:54:15
Subject: Group by within table joins
Previous:From: Meszaros AttilaDate: 2000-09-13 19:22:45
Subject: Re: Optimizing Multiply Joins ???

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group