[postgis-users] Re: [postgis-users] Postgis too slow

[shpr@libero.it]

WWVzLCBpbiBteSBzb2x1dGlvbiBJIFVTRSB0aGUgKml0ZW1xdWVyeSogbW9kZSAobW9kZT1p
dGVtcXVlcnkpIGFzIE9iZSANCmRpZCBpbiBoaXMgc29sdXRpb24uDQoNCj4gTm90ZSB0aGF0
IHRoZSBwcm9ibGVtIEkgZGVzY3JpYmUgaXMgKm5vdCogd2l0aCBpdGVtcXVlcnkgb3IgaXRl
bW5xdWVyeQ0KLg0KPiBJdCBpcyB3aXRoIFN0ZWZhbm9zIHBhcnRpY3VsYXIgdXNlIG9mIHRo
ZSBGSUxURVIgcGFyYW1ldGVyIHRvIHRyeSBhbmQNCj4gbWFrZSBhIGxheWVyIHdoaWNoICph
Y3RzKiBhcyBpZiBpdCBpcyBkb2luZyBhbiBpdGVtcXVlcnkuIEhlIGlzIG5vdA0KPiB1c2lu
ZyB0aGUgbGF5ZXIgaW4gaXRlbXF1ZXJ5IG1vZGUsIGhlIGlzIHVzaW5nIGl0IGluIG5vcm1h
bCBicm93c2UgbW9kDQplDQo+IGFuZCBwdXNoaW5nIHBhcmFtZXRlcnMgaW4gd2hpY2ggd291
bGQgKG9uIGEgc21hbGxlciBkYXRhc2V0KSBjbGVhbmx5DQo+IHN1YnNldCB0aGUgbGF5ZXIg
dXNpbmcgdGhlIHBhcmFtZXRlcnMuIEl0IGlzIGEgY3V0ZSB0cmljaywgYnV0IGl0IGRvZXMN
Cj4gbm90IHNjYWxlIGF0IGFsbCwgYmVjYXVzZSBpbiB0aGUgcHJlc2VuY2Ugb2YgdGhlIHNw
YXRpYWwgcXVlcnkNCj4gYXNzb2NpYXRlZCB3aXRoIGJyb3dzZSBtb2RlLCB0aGUgYXR0cmli
dXRlIHF1ZXJ5IGJlY29tZXMgYSBzZXF1ZW5jZSBzYw0KYW4NCj4gb3ZlciBhbGwgODAwMDAw
IG9mIGhpcyByZWNvcmRzLg0KPiANCj4gIk9iZSwgUmVnaW5hIERORFxcTUlTIiB3cm90ZToN
Cj4gPiANCj4gPiBJIGZpbmQgYWxsIHRoaXMgcHJldHR5IGZhc2NpbmF0aW5nIGFuZCBzbyBm
YXIgZWR1Y2F0aW9uYWwuICBJIGRpZG4ndA0KIHJlYWxpemUNCj4gPiBob3cgdGhlIG1hcHNl
cnZlciBhbmQgcG9zdGdpcyBpbnRlZ3JhdGlvbiB3b3Jrcy4gIEkgaGF2ZSBhIHNpbWlsYXIg
cQ0KdWVyeQ0KPiA+IHNldHVwIHVzaW5nIENHSSBhbmQgdGhlIHNwZWVkIGlzIHByZXR0eSBk
ZWNlbnQgKHVuZGVyIGEgc2Vjb25kIGxvY2FsDQopICAoYnV0DQo+ID4gdGhlIHRhYmxlIEkg
dXNlIGdlbmVyYWxseSBmb3Igc3RyZWV0IHNlZ21lbnQgb25seSBoYXMgNDAsMDAwIHN0cmVl
dCANCnNlZ21lbnRzDQo+ID4gYW5kIG15IG1lbW9yeSBhbmQgcHJvY2Vzc29yIGFyZSBhIGJp
dCBiZXR0ZXIgdGhhbiBTdGVmYW5vJ3MuDQo+ID4gDQo+ID4gT25lIHRoaW5nIEkgd2FzIHdv
bmRlcmluZyBhYm91dCAtIGFuZCB3aGV0aGVyIGFueW9uZSBoYXMgdHJpZWQgdGhpcy4NCj4g
PiBTdGVmYW5vIHNheXMgaGUgaGFzIGEgNjAwIE1oeiBwcm9jZXNzb3Igd2l0aCAxOTJtYiBv
ZiByYW0gYW5kIGFuIDgwMA0KLDAwMA0KPiA+IHJlY29yZCBzZXQuICBJJ20gd29uZGVyaW5n
IGlmIGFueW9uZSBoYXMgYWN0dWFsbHkgdHJpZWQgZG9pbmcgd2hhdCBoDQplIGlzDQo+ID4g
ZG9pbmcgdXNpbmcgMTkybWIgb2YgbWVtb3J5IHdpdGggdGhhdCBtYW55IHJlY29yZHMuICBJ
IHRvbGQgaGltIEkgY2ENCm4gYmFyZWx5DQo+ID4gZ2V0IG15IHNlcnZlciB0byB3b3JrIHdp
dGggYWxsIHRoZSBzZXJ2aWNlcyBpdCBoYXMgdG8gcnVuIGZvciB0aGF0IGwNCml0dGxlDQo+
ID4gYW1vdW50IG9mIG9uLWJvYXJkIG1lbW9yeS4gIEFsbCBteSBzZXJ2ZXJzIGhhdmUgYXQg
bGVhc3QgMjU2TUIgcmFtIC0NCiBldmVuDQo+ID4gdGhlIHJlYWxseSBzdHVwaWQgb25lcyB0
aGF0IGRvIG5vdGhpbmcuDQo+ID4gDQo+ID4gVGhlIG90aGVyIGN1cmlvc2l0eSBJIGhhZCBp
cyB0aGF0IGlmIHlvdSBzZXQgdGhlIExheWVyIHR5cGUgdG8gUVVFUlkNCiBpbnN0ZWFkDQo+
ID4gb2YgTElORSBkb2VzIGl0IHN0aWxsIGluY3VyIHRoZSBzYW1lIHNwYXRpYWwgcXVlcnkg
cGVuYWx0eSAtDQogb3Igd291bGQNCj4gPiBtYXBzZXJ2ZXItDQpwb3N0Z2lzIGJlIHNtYXJ0
IGVub3VnaCB0byBzYXkgKCJJJ20gbm90IGdvaW5nIHRvIHJlbmRlciB0aGlzIHNvDQo+ID4g
anVzdCBuZWVkIHRoZSBleHRlbnQiKSBhbmQgZnVydGhlciBpZiB0aGUgbWFwIG1vZGUgd2Fz
IHNldCB0byBpdGVtcXUNCmVyeQ0KPiA+IGluc3RlYWQgb2YgaXRlbW5xdWVyeSAtDQogaWYg
dGhhdCBtaW5pbWl6ZXMgb24gc3BhdGlhbCBxdWVyeSBwZW5hbHR5IHNpbmNlIGl0DQo+ID4g
a25vd3MgdG8gb25seSBncmFiIGZpcnN0IHJlc3VsdC4NCj4gPiANCj4gPiANCj4gPiANCj4g
PiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiA+IEZyb206IFBhdWwgUmFtc2V5IFtt
YWlsdG86cHJhbXNleUByZWZyYWN0aW9ucy5uZXRdDQo+ID4gU2VudDogV2VkbmVzZGF5LCBN
YXkgMjIsIDIwMDIgNzowOSBQTQ0KPiA+IFRvOiBwb3N0Z2lzLXVzZXJzQHBvc3RnaXMucmVm
cmFjdGlvbnMubmV0DQo+ID4gU3ViamVjdDogUmU6IFtwb3N0Z2lzLXVzZXJzXSBQb3N0Z2lz
IHRvbyBzbG93DQo+ID4gDQo+ID4gT0ssIEkgYW0gbm93IHByZXR0eSBzdXJlIHRoZSBwcm9i
bGVtIHdhcyAoMikgaW4gbXkgcHJldmlvdXMgZW1haWwuIFkNCm91cg0KPiA+IG1hcGZpbGUg
bGF5ZXIgZGVmaW5pdGlvbiBpcyBiZWxvdy4gV2hhdCB5b3UgYXJlIGRvaW5nIGlzIGVtdWxh
dGluZyBhDQpuDQo+ID4gaXRlbSBxdWVyeSBieSB1c2luZyB0aGUgRklMVEVSIHBhcmFtZXRl
ci4gVGhpcyBpcyAqYmFkKi4gSXQgd2lsbCAqbm8NCnQqDQo+ID4gd29yaywgYmVjYXVzZSB0
aGUgc3BhdGlhbCBwYXJhbWV0ZXIgaXMgd2F5IHRvbyBiaWcsIGFuZCB5b3VyIGF0dHJpYnUN
CnRlDQo+ID4gaW5kZXhlcyB3aWxsIG5ldmVyIGV2ZXIgZ2V0IHVzZWQuIFRoZSBwZ3NxbCBx
dWVyeSBvcHRpbWl6ZXIganVzdCBkb2UNCnMNCj4gPiBub3Qga25vdyBob3cgdG8gaGFuZGxl
IHRoaXMgY29tYmluYXRpb24gb2Ygc3BhdGlhbCBhbmQgYXR0cmlidXRlDQo+ID4gaW5kZXhl
cy4NCj4gPiANCj4gPiBUbyB2ZXJpZnkgdGhhdCB0aGlzIGlzIHRoZSBwcm9ibGVtLCBlaXRo
ZXIgKDEpIGNoYW5nZSB5b3VyIEVYVEVOVCBzbw0KPiA+IHRoYXQgaXQgaXMgYSB2ZXJ5ICpz
bWFsbCogYm94IHdoaWNoIGNvbnRhaW5zIGp1c3QgeW91ciBvbmUgdGVzdCByb2FkDQogYW5k
DQo+ID4gdmVyeSBsaXR0bGUgZWxzZS4gTm93IHNlZSBob3cgZmFzdCBpdCBydW5zLiBPciAo
MikgcmVtb3ZlIHRoZSBGSUxURVINCj4gPiBlbnRpcmVseSAoZG9uJ3QgdG8gMT0yLCAqcmVt
b3ZlKiBpdCkgYW5kIHpvb20gaW50byBhIHNtYWxsIGFyZWEuIE5vdw0KIHBhbg0KPiA+IGFy
b3VuZCB0aGUgZGF0YXNldC4gVGhhdCBzaG91bGQgZGVtb25zdHJhdGUgdGhlIG5hdGl2ZSBz
cGF0aWFsIHF1ZXJ5DQo+ID4gc3BlZWQuDQo+ID4gDQo+ID4gWW91IGFyZSBub3QgZ29pbmcg
dG8gYmUgYWJsZSB0byBkbyB0aGlzIHF1ZXJ5IHdpdGggdGhlIHN0YW5kYXJkIENHSQ0KPiA+
IGludGVyZmFjZS4gWW91IGFyZSBnb2luZyB0byBoYXZlIHRvIHVzZSBQSFAgTWFwU2NyaXB0
IGFuZCB1c2UgUEhQIGRpDQpyZWN0DQo+ID4gY29ubmVjdGlvbiB0byBwZ3NxbCB0byBkbyB0
aGUgYXR0cmlidXRlIHF1ZXJ5IGFuZCBmaW5kIHRoZSBleHRlbnQgb2YNCiB0aGUNCj4gPiBy
ZXN1bHRhbnQgbGluZXMsIHRoZW4gc2V0IHRoZSBleHRlbnQgb2YgeW91ciBtYXAgYXBwcm9w
cmlhdGVseSwgdGhlbg0KPiA+IHJlbmRlci4gSWYgeW91IGhhdmUgc2ltcGxlIHF1ZXJpZXMs
IHlvdSBjYW4gdXNlIHRoZSBpdGVtcXVlcnkgaW4gdGhlDQogQ0dJDQo+ID4gaW50ZXJmYWNl
LCBidXQgeW91ciBxdWVyeSBpcyB0b28gY29tcGxleCBmb3IgdGhhdC4NCj4gPiANCj4gPiBU
aGlzIGlzIG1hcCBwb3N0Z2lzIGxheWVyOg0KPiA+IA0KPiA+IExBWUVSDQo+ID4gU1RBVFVT
IE9GRg0KPiA+ICAgTkFNRSAic3RyYWRlUSINCj4gPiBDT05ORUNUSU9OVFlQRSBwb3N0Z2lz
DQo+ID4gQ09OTkVDVElPTiAidXNlcj1wb3N0Z3JlcyBwYXNzd29yZD1wb3N0Z3JlcyBkYm5h
bWU9bWFya2V0IGhvc3Q9c2VydmUNCnINCj4gPiBwb3J0PTU0MzIiDQo+ID4gICBEQVRBICJ0
aGVfZ2VvbSBmcm9tIHN0cmVldHMiDQo+ID4gVFlQRSBMSU5FDQo+ID4gRklMVEVSICIodXBw
ZXIoc3Rfbm1fYmFzZSkgTGlrZSB1cHBlcignJQ0Kc3RyZWV0JScpKSBBTkQgKGxfYXJlYV9p
ZCBMaWtlDQo+ID4gJyV2YWx1ZSUnKQ0KPiA+IEFORCAoJyVudW1iZXIlJz0nJyBvciAnJW51
bWJlciUnIGJldHdlZW4gbF9yZWZhZGRyIGFuZCBsX25yZWZhZGRyIG9yDQo+ID4gJyVudW1i
ZXIlJw0KPiA+IGJldHdlZW4gcl9yZWZhZGRyIGFuZCByX25yZWZhZGRyKSAiDQo+ID4gDQo+
ID4gQ0xBU1MNCj4gPiAgIFNZTUJPTCAwDQo+ID4gICBPVVRMSU5FQ09MT1IgMjUgMjUgMA0K
PiA+IEVORA0KPiA+IFRFTVBMQVRFIG1hcmtldC5odG1sDQo+ID4gRU5EDQo+ID4gDQo+ID4g
LS0NCj4gPiAgICAgICBfXw0KPiA+ICAgICAgLw0KPiA+ICAgICAgfCBQYXVsIFJhbXNleQ0K
PiA+ICAgICAgfCBSZWZyYWN0aW9ucyBSZXNlYXJjaA0KPiA+ICAgICAgfCBFbWFpbDogcHJh
bXNleUByZWZyYWN0aW9ucy5uZXQNCj4gPiAgICAgIHwgUGhvbmU6ICgyNTApIDg4NS0wNjMy
DQo+ID4gICAgICBcXw0KPiA+IA0KPiA+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fDQo+ID4gcG9zdGdpcy11c2VycyBtYWlsaW5nIGxpc3QNCj4g
PiBwb3N0Z2lzLXVzZXJzQHBvc3RnaXMucmVmcmFjdGlvbnMubmV0DQo+ID4gaHR0cDovL3Bv
c3RnaXMucmVmcmFjdGlvbnMubmV0L21haWxtYW4vbGlzdGluZm8vcG9zdGdpcy11c2Vycw0K
PiA+IA0KPiA+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fDQo+ID4gcG9zdGdpcy11c2VycyBtYWlsaW5nIGxpc3QNCj4gPiBwb3N0Z2lzLXVzZXJz
QHBvc3RnaXMucmVmcmFjdGlvbnMubmV0DQo+ID4gaHR0cDovL3Bvc3RnaXMucmVmcmFjdGlv
bnMubmV0L21haWxtYW4vbGlzdGluZm8vcG9zdGdpcy11c2Vycw0KPiANCj4gX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCj4gcG9zdGdpcy11c2Vy
cyBtYWlsaW5nIGxpc3QNCj4gcG9zdGdpcy11c2Vyc0Bwb3N0Z2lzLnJlZnJhY3Rpb25zLm5l
dA0KPiBodHRwOi8vcG9zdGdpcy5yZWZyYWN0aW9ucy5uZXQvbWFpbG1hbi9saXN0aW5mby9w
b3N0Z2lzLXVzZXJzDQo+IA==