[postgis-users] Re: [postgis-users] Re: [postgis-users] Postgis too slow
shpr@libero.it
shpr@libero.it
Thu May 23 15:30:36 2002
b2ssIHdoYXQgSSBqdXN0IHNheSBpcyBub3QgcG9zc2libGUsIGJ1dCB0aGVuIGhvdyBjYW4g
SSBkbyB0aGlzIHdpdGggDQpQSFAgTWFwc2NyaXB0PyBXaGF0IGlzIHRoZSBlcXVpdmFsZW50
IG9mIGl0ZW1xdWVyeSBpbiBQSFAgbWFwc2NyaXB0PyBJIA0KZG9lc24ndCBmaW5kIGl0Pw0K
SW4gb3RoZXIgd29yZHMsIGhvdyBjYW4gSSBmaW5kIGFuIG9iamVjdCBhbmQgY2FsY3VsYXRl
IGl0cyBleHRlbnNpb24gDQp1bmRlciBQSFAgbWFwc2NyaXB0Pw0KSSB0aGlua3MgdGhhdCBp
cyBvbmUgb2YgdGhlIG1haW4gZnVuY3Rpb25hbGl0eSB0aGF0IGEgR0lTIHNob3VsZCBoYXZl
LCANCmJ1dCBJIGRpZG4ndCBmaW5kIGFueSBQSFAgTWFwc2NyaXB0IGFwcGxpY2F0aW9ucyB0
aGF0IGhhdmUgaXQuIE1vcmVvdmVyIA0KSSBkaWRuJ3QgZmluZCBhcHBsaWNhdGlvbnMgdW5k
ZXIgbWFwc2VydmVyIHRoYXQgcmVzb2x2ZSB0aGlzIHByb2JsZW0uDQoNCkFueSBpZGVhPw0K
SXMgdGhlcmUgYSB3YXkgd2l0aCBBU1Agb3IgSkFWQVNlcnZsZXQgdGVjbm9sb2dpZXM/DQoN
ClRoYW5rcw0KU3RlZmFuby4gDQoNCj4gb2ssIEkgZG9uJ3Qgc3RpbGwgdHJ5IGlmIHRoaXMg
aXMgdGhlIHByb2JsZW0sIGJ1dCBJIHRoaW5rIHNvLg0KPiANCj4gSWYgSSBkZXZlbG9wLCBm
b3IgZXhhbXBsZSwgYSBqYXZhIHNlcnZsZXQgdGhhdCBleHRyYWN0IHRoZSBvaWQgKGlzIA0K
PiBwb3NzaWJsZT8gSSB0aGluayBzbykgYW5kIHRoZW4gSSBjcmVhdGUgYSBmaWx0ZXIgcXVl
cnkgb25seSBvbiB0aGlzIA0KPiBhdHRyaWJ1dGUsIGRvIHlvdSB0aGluayB0aGF0IHRoaXMg
Y2FuIHdvcmsgZmFzdGVyPw0KPiANCj4gU3RlZmFuby4NCj4gDQo+IA0KPiA+IE9LLCBJIGFt
IG5vdyBwcmV0dHkgc3VyZSB0aGUgcHJvYmxlbSB3YXMgKDIpIGluIG15IHByZXZpb3VzIGVt
YWlsLiBZDQpvdQ0KPiByDQo+ID4gbWFwZmlsZSBsYXllciBkZWZpbml0aW9uIGlzIGJlbG93
LiBXaGF0IHlvdSBhcmUgZG9pbmcgaXMgZW11bGF0aW5nIGENCm4NCj4gPiBpdGVtIHF1ZXJ5
IGJ5IHVzaW5nIHRoZSBGSUxURVIgcGFyYW1ldGVyLiBUaGlzIGlzICpiYWQqLiBJdCB3aWxs
ICpubw0KdCoNCj4gPiB3b3JrLCBiZWNhdXNlIHRoZSBzcGF0aWFsIHBhcmFtZXRlciBpcyB3
YXkgdG9vIGJpZywgYW5kIHlvdXIgYXR0cmlidQ0KdGUNCj4gPiBpbmRleGVzIHdpbGwgbmV2
ZXIgZXZlciBnZXQgdXNlZC4gVGhlIHBnc3FsIHF1ZXJ5IG9wdGltaXplciBqdXN0IGRvZQ0K
cw0KPiA+IG5vdCBrbm93IGhvdyB0byBoYW5kbGUgdGhpcyBjb21iaW5hdGlvbiBvZiBzcGF0
aWFsIGFuZCBhdHRyaWJ1dGUNCj4gPiBpbmRleGVzLiANCj4gPiANCj4gPiBUbyB2ZXJpZnkg
dGhhdCB0aGlzIGlzIHRoZSBwcm9ibGVtLCBlaXRoZXIgKDEpIGNoYW5nZSB5b3VyIEVYVEVO
VCBzbw0KPiA+IHRoYXQgaXQgaXMgYSB2ZXJ5ICpzbWFsbCogYm94IHdoaWNoIGNvbnRhaW5z
IGp1c3QgeW91ciBvbmUgdGVzdCByb2FkDQogYQ0KPiBuZA0KPiA+IHZlcnkgbGl0dGxlIGVs
c2UuIE5vdyBzZWUgaG93IGZhc3QgaXQgcnVucy4gT3IgKDIpIHJlbW92ZSB0aGUgRklMVEVS
DQo+ID4gZW50aXJlbHkgKGRvbid0IHRvIDE9MiwgKnJlbW92ZSogaXQpIGFuZCB6b29tIGlu
dG8gYSBzbWFsbCBhcmVhLiBOb3cNCiBwDQo+IGFuDQo+ID4gYXJvdW5kIHRoZSBkYXRhc2V0
LiBUaGF0IHNob3VsZCBkZW1vbnN0cmF0ZSB0aGUgbmF0aXZlIHNwYXRpYWwgcXVlcnkNCj4g
PiBzcGVlZC4NCj4gPiANCj4gPiBZb3UgYXJlIG5vdCBnb2luZyB0byBiZSBhYmxlIHRvIGRv
IHRoaXMgcXVlcnkgd2l0aCB0aGUgc3RhbmRhcmQgQ0dJDQo+ID4gaW50ZXJmYWNlLiBZb3Ug
YXJlIGdvaW5nIHRvIGhhdmUgdG8gdXNlIFBIUCBNYXBTY3JpcHQgYW5kIHVzZSBQSFAgZGkN
CnJlDQo+IGN0DQo+ID4gY29ubmVjdGlvbiB0byBwZ3NxbCB0byBkbyB0aGUgYXR0cmlidXRl
IHF1ZXJ5IGFuZCBmaW5kIHRoZSBleHRlbnQgb2YNCiB0DQo+IGhlDQo+ID4gcmVzdWx0YW50
IGxpbmVzLCB0aGVuIHNldCB0aGUgZXh0ZW50IG9mIHlvdXIgbWFwIGFwcHJvcHJpYXRlbHks
IHRoZW4NCj4gPiByZW5kZXIuIElmIHlvdSBoYXZlIHNpbXBsZSBxdWVyaWVzLCB5b3UgY2Fu
IHVzZSB0aGUgaXRlbXF1ZXJ5IGluIHRoZQ0KIEMNCj4gR0kNCj4gPiBpbnRlcmZhY2UsIGJ1
dCB5b3VyIHF1ZXJ5IGlzIHRvbyBjb21wbGV4IGZvciB0aGF0Lg0KPiA+IA0KPiA+IFRoaXMg
aXMgbWFwIHBvc3RnaXMgbGF5ZXI6DQo+ID4gDQo+ID4gTEFZRVINCj4gPiBTVEFUVVMgT0ZG
DQo+ID4gICBOQU1FICJzdHJhZGVRIg0KPiA+IENPTk5FQ1RJT05UWVBFIHBvc3RnaXMNCj4g
PiBDT05ORUNUSU9OICJ1c2VyPXBvc3RncmVzIHBhc3N3b3JkPXBvc3RncmVzIGRibmFtZT1t
YXJrZXQgaG9zdD1zZXJ2ZQ0Kcg0KPiA+IHBvcnQ9NTQzMiINCj4gPiAgIERBVEEgInRoZV9n
ZW9tIGZyb20gc3RyZWV0cyINCj4gPiBUWVBFIExJTkUNCj4gPiBGSUxURVIgIih1cHBlcihz
dF9ubV9iYXNlKSBMaWtlIHVwcGVyKCclDQpzdHJlZXQlJykpIEFORCAobF9hcmVhX2lkIExp
a2UNCj4gPiAnJXZhbHVlJScpDQo+ID4gQU5EICgnJW51bWJlciUnPScnIG9yICclbnVtYmVy
JScgYmV0d2VlbiBsX3JlZmFkZHIgYW5kIGxfbnJlZmFkZHIgb3INCj4gPiAnJW51bWJlciUn
DQo+ID4gYmV0d2VlbiByX3JlZmFkZHIgYW5kIHJfbnJlZmFkZHIpICINCj4gPiANCj4gPiBD
TEFTUw0KPiA+ICAgU1lNQk9MIDANCj4gPiAgIE9VVExJTkVDT0xPUiAyNSAyNSAwDQo+ID4g
RU5EDQo+ID4gVEVNUExBVEUgbWFya2V0Lmh0bWwNCj4gPiBFTkQNCj4gPiANCj4gPiANCj4g
PiAtLSANCj4gPiAgICAgICBfXw0KPiA+ICAgICAgLw0KPiA+ICAgICAgfCBQYXVsIFJhbXNl
eQ0KPiA+ICAgICAgfCBSZWZyYWN0aW9ucyBSZXNlYXJjaA0KPiA+ICAgICAgfCBFbWFpbDog
cHJhbXNleUByZWZyYWN0aW9ucy5uZXQNCj4gPiAgICAgIHwgUGhvbmU6ICgyNTApIDg4NS0w
NjMyDQo+ID4gICAgICBcXw0KPiA+IA0KPiA+IF9fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fDQo+ID4gcG9zdGdpcy11c2VycyBtYWlsaW5nIGxpc3QN
Cj4gPiBwb3N0Z2lzLXVzZXJzQHBvc3RnaXMucmVmcmFjdGlvbnMubmV0DQo+ID4gaHR0cDov
L3Bvc3RnaXMucmVmcmFjdGlvbnMubmV0L21haWxtYW4vbGlzdGluZm8vcG9zdGdpcy11c2Vy
cw0KPiA+IA==