[postgis-users] PostGIS spatial query performance

[Paul Ramsey]

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.