I'm trying to retrieve a big query (bah, not so big, but with a dozen of 
joins) and all I get is this:

010112.17:22:06.050  [5387] DEBUG:  Rel trabajos_docentes: Pages: 3 --> 2.
010112.17:30:48.458  [5412] DEBUG:  geqo_params: ga parameter file
'/var/lib/pgsql/data/pg_geqo'
does not exist or permissions are not setup correctly
010112.17:30:48.475  [5412] DEBUG:  geqo_params: no pool size specified;
using computed value of 1024
010112.17:30:48.475  [5412] DEBUG:  geqo_params: no optimization effort 
specified;
using value of 40
010112.17:30:48.475  [5412] DEBUG:  geqo_params: no number of trials 
specified;
using computed value of 400
010112.17:30:48.475  [5412] DEBUG:  geqo_params: no random seed specified;
using computed value of 979331448
010112.17:30:48.475  [5412] DEBUG:  geqo_params: no selection bias specified;
using default value of 2.000000
010112.17:30:57.936  [5412] DEBUG:  geqo_main: using edge recombination 
crossover [ERX]

Now, when I go to /var/lib/pgsql/data/ I see this:

total 100
-rw-------   1 postgres postgres        4 Dec  5 12:10 PG_VERSION
drwx------   5 postgres postgres     1024 Dec 19 17:41 base/
-rw-------   1 postgres postgres     8192 Jan 12 15:30 pg_control
-rw-------   1 postgres postgres     8192 Jan 12 17:22 pg_database
-r--------   1 postgres postgres     3407 Dec  5 12:10 pg_geqo.sample
-rw-------   1 postgres postgres        0 Dec  5 12:10 pg_group
-rw-------   1 postgres postgres    16384 Dec  5 12:10 pg_group_name_index
-rw-------   1 postgres postgres    16384 Dec  5 12:10 pg_group_sysid_index
-r--------   1 postgres postgres     5729 Dec  5 12:10 pg_hba.conf
-rw-------   1 postgres postgres    16384 Jan 12 17:22 pg_log
-rw-------   1 postgres postgres       58 Dec 16 17:03 pg_pwd
-rw-------   1 postgres postgres        0 Dec 16 17:03 pg_pwd.reload
-rw-------   1 postgres postgres     8192 Dec 16 17:03 pg_shadow
-rw-------   1 postgres postgres     8192 Jan 12 17:22 pg_variable
drwx------   2 postgres postgres     1024 Dec  5 12:10 pg_xlog/
-rw-------   1 postgres postgres       87 Jan 12 15:30 postmaster.opts
-r--------   1 postgres postgres        4 Dec  5 12:10 postmaster.opts.default
-rw-------   1 postgres postgres        4 Jan 12 15:30 postmaster.pid

as you can see, there is a pg_geqo.sample, but not a pg_geqo. Should I rename 
it for it to work? I have been making lots of querys (inserts and selects) 
with no problem at all.

Any help will be appretiated.

-- 
System Administration: It's a dirty job, 
but someone told I had to do it.
-----------------------------------------------------------------
Martï¿½n Marquï¿½s			email: 	martin@math.unl.edu.ar
Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Fri, 12 Jan 2001 17:39:11 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
problems with pg_geqo
"Martin A. Marques" <martin@math.unl.edu.ar> writes:
> as you can see, there is a pg_geqo.sample, but not a pg_geqo. Should I
> rename it for it to work?

Only if you want to mess with the default GEQO parameters.

The debug messages you show don't seem to indicate that anything's
wrong, so I'm not at all clear on what your complaint is.

			regards, tom lane

Fri, 12 Jan 2001 17:09:50 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] problems with pg_geqo 