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
-----------------------------------------------------------------
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 |
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 |