[postgis-users] Performance and memory problems

[David Blasby]

This isnt going to be easy to debug, but:

1. add to postgis_geos.c::
     int debugCounter = 0;

2. to the top of GEOS2POSTGIS() add
      debugCounter ++;
      elog(NOTICE,"debugCounter = %i");

3. run until crash, note the debugCounter id and
	a. comment out the above elog()
	b. add:
		if (debugCounter == <number it crashes on>)
		{
			elog(NOTICE,"this GEOS geometry is causing a crash: %s",GEOSasText(g) );
		}

4. if this isnt helping then you'll have to run gdb on postgresql