[postgis-users] Re: Help: Performance of spatial query
dblasby at refractions.net
Fri Mar 26 13:06:19 PST 2004
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.
More information about the postgis-users