[postgis-users] Performance and memory problems

David Blasby dblasby at refractions.net
Thu Dec 4 11:27:06 PST 2003

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

More information about the postgis-users mailing list