[postgis-users] PostGIS spatial query performance

Paul Ramsey pramsey at refractions.net
Fri Aug 9 08:16:22 PDT 2002


Jan Hartmann wrote:

> neighborhoods (10381), all from pretty large shapefiles (10M). Positive
> queries were efficient (40 sec. at most), negative queries with subselects
> not much slower for municipalities and districts, but failing for
> neighborhoods ("pg_recvbuf: unexpected end on client connection"). 

If you can reduce the query set to the minimum number of features and
simplest SQL necessray to cause the above error, and sent us that data,
it would be helpful. You have found a case which kills the backend it
looks like.

P.




More information about the postgis-users mailing list