[postgis-users] Re: [postgis-users] Postgis too slow
shpr@libero.it
shpr@libero.it
Thu May 23 07:55:20 2002
b2ssIEkgZG9uJ3Qgc3RpbGwgdHJ5IGlmIHRoaXMgaXMgdGhlIHByb2JsZW0sIGJ1dCBJIHRo
aW5rIHNvLg0KDQpJZiBJIGRldmVsb3AsIGZvciBleGFtcGxlLCBhIGphdmEgc2VydmxldCB0
aGF0IGV4dHJhY3QgdGhlIG9pZCAoaXMgDQpwb3NzaWJsZT8gSSB0aGluayBzbykgYW5kIHRo
ZW4gSSBjcmVhdGUgYSBmaWx0ZXIgcXVlcnkgb25seSBvbiB0aGlzIA0KYXR0cmlidXRlLCBk
byB5b3UgdGhpbmsgdGhhdCB0aGlzIGNhbiB3b3JrIGZhc3Rlcj8NCg0KU3RlZmFuby4NCg0K
DQo+IE9LLCBJIGFtIG5vdyBwcmV0dHkgc3VyZSB0aGUgcHJvYmxlbSB3YXMgKDIpIGluIG15
IHByZXZpb3VzIGVtYWlsLiBZb3UNCnINCj4gbWFwZmlsZSBsYXllciBkZWZpbml0aW9uIGlz
IGJlbG93LiBXaGF0IHlvdSBhcmUgZG9pbmcgaXMgZW11bGF0aW5nIGFuDQo+IGl0ZW0gcXVl
cnkgYnkgdXNpbmcgdGhlIEZJTFRFUiBwYXJhbWV0ZXIuIFRoaXMgaXMgKmJhZCouIEl0IHdp
bGwgKm5vdCoNCj4gd29yaywgYmVjYXVzZSB0aGUgc3BhdGlhbCBwYXJhbWV0ZXIgaXMgd2F5
IHRvbyBiaWcsIGFuZCB5b3VyIGF0dHJpYnV0ZQ0KPiBpbmRleGVzIHdpbGwgbmV2ZXIgZXZl
ciBnZXQgdXNlZC4gVGhlIHBnc3FsIHF1ZXJ5IG9wdGltaXplciBqdXN0IGRvZXMNCj4gbm90
IGtub3cgaG93IHRvIGhhbmRsZSB0aGlzIGNvbWJpbmF0aW9uIG9mIHNwYXRpYWwgYW5kIGF0
dHJpYnV0ZQ0KPiBpbmRleGVzLiANCj4gDQo+IFRvIHZlcmlmeSB0aGF0IHRoaXMgaXMgdGhl
IHByb2JsZW0sIGVpdGhlciAoMSkgY2hhbmdlIHlvdXIgRVhURU5UIHNvDQo+IHRoYXQgaXQg
aXMgYSB2ZXJ5ICpzbWFsbCogYm94IHdoaWNoIGNvbnRhaW5zIGp1c3QgeW91ciBvbmUgdGVz
dCByb2FkIGENCm5kDQo+IHZlcnkgbGl0dGxlIGVsc2UuIE5vdyBzZWUgaG93IGZhc3QgaXQg
cnVucy4gT3IgKDIpIHJlbW92ZSB0aGUgRklMVEVSDQo+IGVudGlyZWx5IChkb24ndCB0byAx
PTIsICpyZW1vdmUqIGl0KSBhbmQgem9vbSBpbnRvIGEgc21hbGwgYXJlYS4gTm93IHANCmFu
DQo+IGFyb3VuZCB0aGUgZGF0YXNldC4gVGhhdCBzaG91bGQgZGVtb25zdHJhdGUgdGhlIG5h
dGl2ZSBzcGF0aWFsIHF1ZXJ5DQo+IHNwZWVkLg0KPiANCj4gWW91IGFyZSBub3QgZ29pbmcg
dG8gYmUgYWJsZSB0byBkbyB0aGlzIHF1ZXJ5IHdpdGggdGhlIHN0YW5kYXJkIENHSQ0KPiBp
bnRlcmZhY2UuIFlvdSBhcmUgZ29pbmcgdG8gaGF2ZSB0byB1c2UgUEhQIE1hcFNjcmlwdCBh
bmQgdXNlIFBIUCBkaXJlDQpjdA0KPiBjb25uZWN0aW9uIHRvIHBnc3FsIHRvIGRvIHRoZSBh
dHRyaWJ1dGUgcXVlcnkgYW5kIGZpbmQgdGhlIGV4dGVudCBvZiB0DQpoZQ0KPiByZXN1bHRh
bnQgbGluZXMsIHRoZW4gc2V0IHRoZSBleHRlbnQgb2YgeW91ciBtYXAgYXBwcm9wcmlhdGVs
eSwgdGhlbg0KPiByZW5kZXIuIElmIHlvdSBoYXZlIHNpbXBsZSBxdWVyaWVzLCB5b3UgY2Fu
IHVzZSB0aGUgaXRlbXF1ZXJ5IGluIHRoZSBDDQpHSQ0KPiBpbnRlcmZhY2UsIGJ1dCB5b3Vy
IHF1ZXJ5IGlzIHRvbyBjb21wbGV4IGZvciB0aGF0Lg0KPiANCj4gVGhpcyBpcyBtYXAgcG9z
dGdpcyBsYXllcjoNCj4gDQo+IExBWUVSDQo+IFNUQVRVUyBPRkYNCj4gICBOQU1FICJzdHJh
ZGVRIg0KPiBDT05ORUNUSU9OVFlQRSBwb3N0Z2lzDQo+IENPTk5FQ1RJT04gInVzZXI9cG9z
dGdyZXMgcGFzc3dvcmQ9cG9zdGdyZXMgZGJuYW1lPW1hcmtldCBob3N0PXNlcnZlcg0KPiBw
b3J0PTU0MzIiDQo+ICAgREFUQSAidGhlX2dlb20gZnJvbSBzdHJlZXRzIg0KPiBUWVBFIExJ
TkUNCj4gRklMVEVSICIodXBwZXIoc3Rfbm1fYmFzZSkgTGlrZSB1cHBlcignJXN0cmVldCUn
KSkgQU5EIChsX2FyZWFfaWQgTGlrZQ0KPiAnJXZhbHVlJScpDQo+IEFORCAoJyVudW1iZXIl
Jz0nJyBvciAnJW51bWJlciUnIGJldHdlZW4gbF9yZWZhZGRyIGFuZCBsX25yZWZhZGRyIG9y
DQo+ICclbnVtYmVyJScNCj4gYmV0d2VlbiByX3JlZmFkZHIgYW5kIHJfbnJlZmFkZHIpICIN
Cj4gDQo+IENMQVNTDQo+ICAgU1lNQk9MIDANCj4gICBPVVRMSU5FQ09MT1IgMjUgMjUgMA0K
PiBFTkQNCj4gVEVNUExBVEUgbWFya2V0Lmh0bWwNCj4gRU5EDQo+IA0KPiANCj4gLS0gDQo+
ICAgICAgIF9fDQo+ICAgICAgLw0KPiAgICAgIHwgUGF1bCBSYW1zZXkNCj4gICAgICB8IFJl
ZnJhY3Rpb25zIFJlc2VhcmNoDQo+ICAgICAgfCBFbWFpbDogcHJhbXNleUByZWZyYWN0aW9u
cy5uZXQNCj4gICAgICB8IFBob25lOiAoMjUwKSA4ODUtMDYzMg0KPiAgICAgIFxfDQo+IA0K
PiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KPiBw
b3N0Z2lzLXVzZXJzIG1haWxpbmcgbGlzdA0KPiBwb3N0Z2lzLXVzZXJzQHBvc3RnaXMucmVm
cmFjdGlvbnMubmV0DQo+IGh0dHA6Ly9wb3N0Z2lzLnJlZnJhY3Rpb25zLm5ldC9tYWlsbWFu
L2xpc3RpbmZvL3Bvc3RnaXMtdXNlcnMNCj4g