[postgis-users] Re: Help: Performance of spatial query

[David Blasby]

Paul Ramsey wrote:

> Could be a degenerate case in the distance spheroid function?

It could be, but its unlikely.

The easiest way to find out would be to:
1. compile PostGIS with the -g option (to get debug information in it)
2. make sure valgrind is installed on your system
3. run the postmaster with valgrind (ie. "valgrind postmaster -D ...")
4. run your query
5. see where valgrind says it died.

dave