Re: Problems with genetic optimizer

> > The result of the query if I set the sequential search on is this:
>
> > convert=# select * from box_tmp where ebre &&
> > box('(470758.555,354028.145),(470758.525,354028.115)'::box);
> > pqReadData() -- backend closed the channel unexpectedly.
>
> Urk. That's not supposed to happen. There should be a core file
> left in your PGDATA/base/dbname/ directory --- can you provide a
> backtrace from that file using gdb?
>
> regards, tom lane

No, I'm sorry, but there is no core file. I tried to debug the query and
this are the relults:

/opt/local/DWH/bin/postmaster: ServerLoop: handling reading 5
/opt/local/DWH/bin/postmaster: ServerLoop: handling reading 5
/opt/local/DWH/bin/postmaster: ServerLoop: handling writing 5
/opt/local/DWH/bin/postmaster: BackendStartup: pid 679 user postgres db
convert
socket 5
/opt/local/DWH/bin/postmaster child[679]: starting with
(/opt/local/DWH/bin/post
gres -d2 -v131072 -p convert )
FindExec: found "/opt/local/DWH/bin/postgres" using argv[0]
started: host=localhost user=postgres database=convert
InitPostgres
StartTransactionCommand
query: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: select * from box_tmp where ebre &&
('(470758.555,354028.145),(470758.525
,354028.115)'::box);
ProcessQuery
/opt/local/DWH/bin/postmaster: reaping dead processes...
/opt/local/DWH/bin/postmaster: CleanupProc: pid 679 exited with status
11
Server process (pid 679) exited with status 11 at Wed Oct 25 09:04:25
2000
Terminating any active server processes...
Server processes were terminated at Wed Oct 25 09:04:25 2000
Reinitializing shared memory and semaphores
shmem_exit(0)
binding ShmemCreate(key=52e325, size=1104896)
/opt/local/DWH/bin/postmaster: ServerLoop: handling reading 5
/opt/local/DWH/bin/postmaster: ServerLoop: handling reading 5
/opt/local/DWH/bin/postmaster: ServerLoop: handling writing 5
The Data Base System is starting up
/opt/local/DWH/bin/postmaster: ServerLoop: handling writing 5
DEBUG: Data Base System is starting up at Wed Oct 25 09:04:25 2000
DEBUG: Data Base System was interrupted being in production at Wed Oct
25 09:03
:52 2000
DEBUG: Data Base System is in production state at Wed Oct 25 09:04:25
2000
proc_exit(0)
shmem_exit(0)
exit(0)
/opt/local/DWH/bin/postmaster: reaping dead processes...

Don't know if this is helping you
Peter

--
Bezirksfinanzdirektion Muenchen
Vermessungsabteilung
.........................................................
Peter Keller : Tel: (+49) 089-2190-2594
Vermessungsrat : Fax: (+49) 089-2190-2459
Alexandrastr. 3 : mailto:Peter(dot)Keller(at)bvv(dot)bayern(dot)de
80538 Muenchen : web: http://www.bayern.de/vermessung