Re: Problems with genetic optimizer

From: Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: postgres <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problems with genetic optimizer
Date: 2000-10-26 06:25:26
Message-ID: 39F7CE56.60E990DA@bvv.bayern.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Keller(at)bvv(dot)bayern(dot)de
80538 Muenchen : web: http://www.bayern.de/vermessung

In response to

Browse pgsql-general by date

  From Date Subject
Next Message DaVinci 2000-10-26 09:23:54 Array size and iterate...
Previous Message Cristóvão B. B. Dalla Costa 2000-10-26 05:19:57 postgresql && clusters