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: