Re: Problems with genetic optimizer
От | Peter Keller |
---|---|
Тема | Re: Problems with genetic optimizer |
Дата | |
Msg-id | 39F7CE56.60E990DA@bvv.bayern.de обсуждение исходный текст |
Ответ на | Problems with genetic optimizer (Peter Keller <peter.keller@bvv.bayern.de>) |
Список | 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 по дате отправления: