[postgis-users] RE: [postgis-users] Postgis too slow
shpr@libero.it
shpr@libero.it
Thu May 23 16:16:10 2002
SSB0cmllZCB0byBjaGFuZ2UgZnJvbSBsaW5lIHRvIHF1ZXJ5IGFuZCB0aGUgYmlnIGFkdmFu
dGFnZSB0aGF0IEkgDQpub3RpY2UgaXMgdGhlIGZvbGxvd2luZzoNCg0KaWYgSSB3cml0ZSBh
IGZpbHRlciBvZiB0aGlzIHRpcG8NCg0KZmlsdGVyICJvaWQgPSAnJW51bWJlciciDQoNCnRo
ZSBxdWVyeSBpcyBldmFsdWF0ZWQgaW1tZWRpYXRlbHkhIQ0KDQpUaGlzIHNvbHV0aW9uIGdp
dmUgbWUgYSBwb3NzaWJpbGl0eSB0byB3cml0ZSBhIEphdmEgU2VydmxldCBvciBBU1AgDQph
cHBsaWNhdGlvbiB3aGljaCBleHRyYWN0IHRoZSByaWdodCBvaWQgZnJvbSBwb3N0Z3JlcyBh
bmQgdGhlbiByZWRpcmVjdCANCnRoZSBxdWVyeSB0byBtYXBzZXJ2ZXIuIEkgYmVsaWV2ZSB0
aGF0IHRoaXMgc29sdXRpb24gc2hvdWxkIGJlIHBvc3NpYmxlIQ0KDQpUaGFua3MNCiANCg0K
PiBJIGZpbmQgYWxsIHRoaXMgcHJldHR5IGZhc2NpbmF0aW5nIGFuZCBzbyBmYXIgZWR1Y2F0
aW9uYWwuICBJIGRpZG4ndCByDQplYWxpemUNCj4gaG93IHRoZSBtYXBzZXJ2ZXIgYW5kIHBv
c3RnaXMgaW50ZWdyYXRpb24gd29ya3MuICBJIGhhdmUgYSBzaW1pbGFyIHF1ZQ0KcnkNCj4g
c2V0dXAgdXNpbmcgQ0dJIGFuZCB0aGUgc3BlZWQgaXMgcHJldHR5IGRlY2VudCAodW5kZXIg
YSBzZWNvbmQgbG9jYWwpIA0KIChidXQNCj4gdGhlIHRhYmxlIEkgdXNlIGdlbmVyYWxseSBm
b3Igc3RyZWV0IHNlZ21lbnQgb25seSBoYXMgNDAsMDAwIHN0cmVldCBzZQ0KZ21lbnRzDQo+
IGFuZCBteSBtZW1vcnkgYW5kIHByb2Nlc3NvciBhcmUgYSBiaXQgYmV0dGVyIHRoYW4gU3Rl
ZmFubydzLiANCj4gDQo+IE9uZSB0aGluZyBJIHdhcyB3b25kZXJpbmcgYWJvdXQgLSBhbmQg
d2hldGhlciBhbnlvbmUgaGFzIHRyaWVkIHRoaXMuDQo+IFN0ZWZhbm8gc2F5cyBoZSBoYXMg
YSA2MDAgTWh6IHByb2Nlc3NvciB3aXRoIDE5Mm1iIG9mIHJhbSBhbmQgYW4gODAwLDANCjAw
DQo+IHJlY29yZCBzZXQuICBJJ20gd29uZGVyaW5nIGlmIGFueW9uZSBoYXMgYWN0dWFsbHkg
dHJpZWQgZG9pbmcgd2hhdCBoZSANCmlzDQo+IGRvaW5nIHVzaW5nIDE5Mm1iIG9mIG1lbW9y
eSB3aXRoIHRoYXQgbWFueSByZWNvcmRzLiAgSSB0b2xkIGhpbSBJIGNhbiANCmJhcmVseQ0K
PiBnZXQgbXkgc2VydmVyIHRvIHdvcmsgd2l0aCBhbGwgdGhlIHNlcnZpY2VzIGl0IGhhcyB0
byBydW4gZm9yIHRoYXQgbGl0DQp0bGUNCj4gYW1vdW50IG9mIG9uLWJvYXJkIG1lbW9yeS4g
IEFsbCBteSBzZXJ2ZXJzIGhhdmUgYXQgbGVhc3QgMjU2TUIgcmFtIC0NCiBldmVuDQo+IHRo
ZSByZWFsbHkgc3R1cGlkIG9uZXMgdGhhdCBkbyBub3RoaW5nLg0KPiANCj4gVGhlIG90aGVy
IGN1cmlvc2l0eSBJIGhhZCBpcyB0aGF0IGlmIHlvdSBzZXQgdGhlIExheWVyIHR5cGUgdG8g
UVVFUlkgaQ0KbnN0ZWFkDQo+IG9mIExJTkUgZG9lcyBpdCBzdGlsbCBpbmN1ciB0aGUgc2Ft
ZSBzcGF0aWFsIHF1ZXJ5IHBlbmFsdHkgLSBvciB3b3VsZA0KPiBtYXBzZXJ2ZXItDQpwb3N0
Z2lzIGJlIHNtYXJ0IGVub3VnaCB0byBzYXkgKCJJJ20gbm90IGdvaW5nIHRvIHJlbmRlciB0
aGlzIHNvDQo+IGp1c3QgbmVlZCB0aGUgZXh0ZW50IikgYW5kIGZ1cnRoZXIgaWYgdGhlIG1h
cCBtb2RlIHdhcyBzZXQgdG8gaXRlbXF1ZXINCnkNCj4gaW5zdGVhZCBvZiBpdGVtbnF1ZXJ5
IC0NCiBpZiB0aGF0IG1pbmltaXplcyBvbiBzcGF0aWFsIHF1ZXJ5IHBlbmFsdHkgc2luY2Ug
aXQNCj4ga25vd3MgdG8gb25seSBncmFiIGZpcnN0IHJlc3VsdC4NCj4gDQo+IA0KPiAgDQo+
IA0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9tOiBQYXVsIFJhbXNleSBb
bWFpbHRvOnByYW1zZXlAcmVmcmFjdGlvbnMubmV0XQ0KPiBTZW50OiBXZWRuZXNkYXksIE1h
eSAyMiwgMjAwMiA3OjA5IFBNDQo+IFRvOiBwb3N0Z2lzLXVzZXJzQHBvc3RnaXMucmVmcmFj
dGlvbnMubmV0DQo+IFN1YmplY3Q6IFJlOiBbcG9zdGdpcy11c2Vyc10gUG9zdGdpcyB0b28g
c2xvdw0KPiANCj4gDQo+IE9LLCBJIGFtIG5vdyBwcmV0dHkgc3VyZSB0aGUgcHJvYmxlbSB3
YXMgKDIpIGluIG15IHByZXZpb3VzIGVtYWlsLiBZb3UNCnINCj4gbWFwZmlsZSBsYXllciBk
ZWZpbml0aW9uIGlzIGJlbG93LiBXaGF0IHlvdSBhcmUgZG9pbmcgaXMgZW11bGF0aW5nIGFu
DQo+IGl0ZW0gcXVlcnkgYnkgdXNpbmcgdGhlIEZJTFRFUiBwYXJhbWV0ZXIuIFRoaXMgaXMg
KmJhZCouIEl0IHdpbGwgKm5vdCoNCj4gd29yaywgYmVjYXVzZSB0aGUgc3BhdGlhbCBwYXJh
bWV0ZXIgaXMgd2F5IHRvbyBiaWcsIGFuZCB5b3VyIGF0dHJpYnV0ZQ0KPiBpbmRleGVzIHdp
bGwgbmV2ZXIgZXZlciBnZXQgdXNlZC4gVGhlIHBnc3FsIHF1ZXJ5IG9wdGltaXplciBqdXN0
IGRvZXMNCj4gbm90IGtub3cgaG93IHRvIGhhbmRsZSB0aGlzIGNvbWJpbmF0aW9uIG9mIHNw
YXRpYWwgYW5kIGF0dHJpYnV0ZQ0KPiBpbmRleGVzLiANCj4gDQo+IFRvIHZlcmlmeSB0aGF0
IHRoaXMgaXMgdGhlIHByb2JsZW0sIGVpdGhlciAoMSkgY2hhbmdlIHlvdXIgRVhURU5UIHNv
DQo+IHRoYXQgaXQgaXMgYSB2ZXJ5ICpzbWFsbCogYm94IHdoaWNoIGNvbnRhaW5zIGp1c3Qg
eW91ciBvbmUgdGVzdCByb2FkIGENCm5kDQo+IHZlcnkgbGl0dGxlIGVsc2UuIE5vdyBzZWUg
aG93IGZhc3QgaXQgcnVucy4gT3IgKDIpIHJlbW92ZSB0aGUgRklMVEVSDQo+IGVudGlyZWx5
IChkb24ndCB0byAxPTIsICpyZW1vdmUqIGl0KSBhbmQgem9vbSBpbnRvIGEgc21hbGwgYXJl
YS4gTm93IHANCmFuDQo+IGFyb3VuZCB0aGUgZGF0YXNldC4gVGhhdCBzaG91bGQgZGVtb25z
dHJhdGUgdGhlIG5hdGl2ZSBzcGF0aWFsIHF1ZXJ5DQo+IHNwZWVkLg0KPiANCj4gWW91IGFy
ZSBub3QgZ29pbmcgdG8gYmUgYWJsZSB0byBkbyB0aGlzIHF1ZXJ5IHdpdGggdGhlIHN0YW5k
YXJkIENHSQ0KPiBpbnRlcmZhY2UuIFlvdSBhcmUgZ29pbmcgdG8gaGF2ZSB0byB1c2UgUEhQ
IE1hcFNjcmlwdCBhbmQgdXNlIFBIUCBkaXJlDQpjdA0KPiBjb25uZWN0aW9uIHRvIHBnc3Fs
IHRvIGRvIHRoZSBhdHRyaWJ1dGUgcXVlcnkgYW5kIGZpbmQgdGhlIGV4dGVudCBvZiB0DQpo
ZQ0KPiByZXN1bHRhbnQgbGluZXMsIHRoZW4gc2V0IHRoZSBleHRlbnQgb2YgeW91ciBtYXAg
YXBwcm9wcmlhdGVseSwgdGhlbg0KPiByZW5kZXIuIElmIHlvdSBoYXZlIHNpbXBsZSBxdWVy
aWVzLCB5b3UgY2FuIHVzZSB0aGUgaXRlbXF1ZXJ5IGluIHRoZSBDDQpHSQ0KPiBpbnRlcmZh
Y2UsIGJ1dCB5b3VyIHF1ZXJ5IGlzIHRvbyBjb21wbGV4IGZvciB0aGF0Lg0KPiANCj4gVGhp
cyBpcyBtYXAgcG9zdGdpcyBsYXllcjoNCj4gDQo+IExBWUVSDQo+IFNUQVRVUyBPRkYNCj4g
ICBOQU1FICJzdHJhZGVRIg0KPiBDT05ORUNUSU9OVFlQRSBwb3N0Z2lzDQo+IENPTk5FQ1RJ
T04gInVzZXI9cG9zdGdyZXMgcGFzc3dvcmQ9cG9zdGdyZXMgZGJuYW1lPW1hcmtldCBob3N0
PXNlcnZlcg0KPiBwb3J0PTU0MzIiDQo+ICAgREFUQSAidGhlX2dlb20gZnJvbSBzdHJlZXRz
Ig0KPiBUWVBFIExJTkUNCj4gRklMVEVSICIodXBwZXIoc3Rfbm1fYmFzZSkgTGlrZSB1cHBl
cignJXN0cmVldCUnKSkgQU5EIChsX2FyZWFfaWQgTGlrZQ0KPiAnJXZhbHVlJScpDQo+IEFO
RCAoJyVudW1iZXIlJz0nJyBvciAnJW51bWJlciUnIGJldHdlZW4gbF9yZWZhZGRyIGFuZCBs
X25yZWZhZGRyIG9yDQo+ICclbnVtYmVyJScNCj4gYmV0d2VlbiByX3JlZmFkZHIgYW5kIHJf
bnJlZmFkZHIpICINCj4gDQo+IENMQVNTDQo+ICAgU1lNQk9MIDANCj4gICBPVVRMSU5FQ09M
T1IgMjUgMjUgMA0KPiBFTkQNCj4gVEVNUExBVEUgbWFya2V0Lmh0bWwNCj4gRU5EDQo+IA0K
PiANCj4gLS0gDQo+ICAgICAgIF9fDQo+ICAgICAgLw0KPiAgICAgIHwgUGF1bCBSYW1zZXkN
Cj4gICAgICB8IFJlZnJhY3Rpb25zIFJlc2VhcmNoDQo+ICAgICAgfCBFbWFpbDogcHJhbXNl
eUByZWZyYWN0aW9ucy5uZXQNCj4gICAgICB8IFBob25lOiAoMjUwKSA4ODUtMDYzMg0KPiAg
ICAgIFxfDQo+IA0KPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fXw0KPiBwb3N0Z2lzLXVzZXJzIG1haWxpbmcgbGlzdA0KPiBwb3N0Z2lzLXVzZXJz
QHBvc3RnaXMucmVmcmFjdGlvbnMubmV0DQo+IGh0dHA6Ly9wb3N0Z2lzLnJlZnJhY3Rpb25z
Lm5ldC9tYWlsbWFuL2xpc3RpbmZvL3Bvc3RnaXMtdXNlcnMNCj4gDQo+IF9fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQo+IHBvc3RnaXMtdXNlcnMg
bWFpbGluZyBsaXN0DQo+IHBvc3RnaXMtdXNlcnNAcG9zdGdpcy5yZWZyYWN0aW9ucy5uZXQN
Cj4gaHR0cDovL3Bvc3RnaXMucmVmcmFjdGlvbnMubmV0L21haWxtYW4vbGlzdGluZm8vcG9z
dGdpcy11c2Vycw0KPiA=