Re: Problems with genetic optimizer - Mailing list pgsql-general

From Peter Keller
Subject Re: Problems with genetic optimizer
Date
Msg-id 39F7CE56.60E990DA@bvv.bayern.de
Whole thread Raw
In response to Problems with genetic optimizer  (Peter Keller <peter.keller@bvv.bayern.de>)
List pgsql-general
> No, I'm sorry, but there is no core file.
>
> You're probably running one of those setups where the postmaster is
> started with a ulimit setting that prevents core dumps.  You might
> want to look into changing that for future debugging purposes.

Yes, you are right, I changed it in /etc/profile.

>
> > 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
>
> Now that I think about it, are there any NULL entries in box_tmp.ebre?
> The box_overlap function, like practically all of the geometric
> operators :-(, doesn't defend itself against NULL inputs in 7.0 and
> earlier releases.

YES!! I deleted the NULL entries. Now it works. Thanks!!!

Peter

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

pgsql-general by date:

Previous
From: "Enrico Comini"
Date:
Subject: JDBC DRIVER
Next
From: "Robert D. Nelson"
Date:
Subject: RE: Postgres 7.0.2-2 on Red Hat 7.0?