[postgis-users] Performance and memory problems

[Andrea Aime]

Andrea Aime wrote:

> Andrea Aime wrote:
> 
>> strk wrote:
>>
>>
>>> Ask on the pgsql-hackers mailing list about postmaster
>>> stack trace (and please let me know).
>>>
>>> --strk;
>>>
>>
> 
> I followed David directions and found what geometry makes
> the thing crash:
> 
> NOTICE:  The geometry that makes it crash: LINESTRING 
> (-161.1793670654300001
> 66.2170028686523011, -161.1728210449219887 66.2185287475585938)
> 

I really did not make sense, so I increased the debug output and found
this:

NOTICE:  debugCounter = 2195, type = 7
NOTICE:  Number of geometries 180
NOTICE:  debugCounter = 2196, type = 2
NOTICE:  debugCounter = 2197, type = 2
NOTICE:  debugCounter = 2198, type = 2
NOTICE:  debugCounter = 2199, type = 2
NOTICE:  debugCounter = 2200, type = 2
NOTICE:  The geometry that makes crash: LINESTRING (-161.1793670654300001
66.2170028686523011, -161.1728210449219887 66.2185287475585938)
Segmentation fault (core dumped)

Ha, it's a geometry collection that makes it crash! By the way, it's not
the first non empty collection, there are other two (I also added a counter
for this while writing this mail).

Best regards
Andrea Aime