[postgis-users] PosGis shutdown with request using within

[Markus Schaber]

Hi, Xavier,

Xavier Mauclaire wrote:

> This request usually works well but in some case  (more the 10000
> building and 350 polygons in the second layer)  this query shutdowns the
> postmaster service and sometimes, more annoyingly, it makes the server
> no more usable  and the only thing to do is to do a hard reset.

Do you mean a hard reset of the machine, or a hard kill of the
Postmaster processes?

In the former case, I'd suspect a kernel or hardware problem, as PostGIS
and PostgreSQL should not be able to lock a machine in such a way.

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org