problems with pg_geqo

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: problems with pg_geqo
Date: 2001-01-12 20:39:11
Message-ID: 01011217391105.04615@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Moschuk 2001-01-12 20:40:03 Re: exit status 26
Previous Message Martin A. Marques 2001-01-12 20:34:07 Re: still no log

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2001-01-12 21:07:56 RE: CRCs
Previous Message Nathan Myers 2001-01-12 20:35:14 CRCs