problems with pg_geqo - Mailing list pgsql-hackers

From Martin A. Marques
Subject problems with pg_geqo
Date
Msg-id 01011217391105.04615@math.unl.edu.ar
Whole thread Raw
Responses Re: problems with pg_geqo
List pgsql-hackers
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
-----------------------------------------------------------------

pgsql-hackers by date:

Previous
From: "Martin A. Marques"
Date:
Subject: Re: still no log
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: CRCs