[postgis-users] Postgis too slow
shpr@libero.it
shpr@libero.it
Wed May 22 23:30:54 2002
Tm93IChpbiB0aGVzZSBkYXlzKSBJIGFtIG5vdCBhdCB3b3JrIHBsYWNlIGFuZCBJIGRvbid0
IHJlbWVtYmVyIGV4YWN0bHkgDQp0aGUgY3B1IHBvd2VyIGJ1dCBJIHRoaW5rIGFib3V0IFBl
bnRpdW0gMyA2MDBNaHogb3IgbW9yZSBhbmQgMTkyTWIgb2YgDQpSQU0gKFNDU0kgdGVjbm9s
b2d5KS4NClBvc3RnaXMgYW5kIFBvc3RncmVzcWwgYXJlIG9uIHRoZSBzYW1lIG1hY2hpbmUu
DQpJJ20gdXNpbmcgbGlicHEuc28uMi4xIChJIGRvbid0IGtub3cgaWYgaXMgdGhlIHJpZ2h0
IHZlcnNpb24pDQpJIGRvIGEgc2ltcGxlIHF1ZXJ5LCBzbyBvbmx5IG9uZSBvYmplY3Qgc2hv
dWxkIGJlIHJldHVybmVkLg0KV2l0aG91dCB0aGUgcG9zdGdpcyBsYXllciB0aGUgem9vbSBh
bmQgcGFuIG9wZXJhdGlvbnMgYXJlIGRvbmUgaW4gYSBmZXcgDQpzZWNvbmRzLg0KDQpTdGVm
YW5vLg0KDQpQUy4gQ2FuIHRoaXMgcHJvYmxlbSBkZXBlbmQgKHBlcmhhcHMpIG9uIGhvdyBJ
IGhhdmUgaW5zdGFsbGVkIHNvbWUgDQpzb2Z0d2FyZSBjb21wb25lbnQ/DQogDQoNCg0KPiBJ
IGRvbid0IGtub3cgaWYgdGhlc2UgaGF2ZSBiZWVuIGFuc3dlcmVkIGJlZm9yZQ0KPiANCj4g
MSkgQnV0IHdoYXQga2luZCBvZiBib3ggaXMgeW91ciBtYXBzZXJ2ZXIgYW5kIHBvc3RnaXMg
cnVubmluZyBvbj8gKGUuZw0KPiBwcm9jZXNzb3IgYW5kIG1lbW9yeSkgLQ0KIEkgYXNzdW1l
IGl0cyB0aGUgc2FtZSBib3ggc2luY2UgeW91IGRvbid0IGhhdmUgYQ0KPiBob3N0IGxpbmUg
aW4gdGhlcmUuDQo+IA0KPiAyKSBBcmUgeW91IHVzaW5nIHRoZSBsYXRlc3QgbGlicHEgb24g
eW91ciB3ZWJzZXJ2ZXI/DQo+IDMpIEZvciBhIGdlbmVyYWwgc3RyZWV0IHNlYXJjaCBxdWVy
eSAtIGhvdyBtYW55IHR1cGxlcyBhcmUgcmV0dXJuZWQ/IA0KPiA0KSBXaGF0IGlzIHRoZSBn
ZW5lcmFsIGltYWdlIHNpemUgaW4ga2lsb2J5dGVzIChvZiB0aGUgcmVuZGVyZWQgaW1hZ2Up
DQo+IDUpIFdpdGhvdXQgdGhlIHBvc3RnaXMgbGF5ZXIgKGp1c3QgZG9pbmcgcGFubmluZyBh
bmQgem9vbWluZyBldGMuKSAtIEkNCj4gYXNzdW1lIHRoZSBzcGVlZCBpcyBkZWNlbnQ/DQo+
IA0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9tOiBzaHByQGxpYmVyby5p
dCBbbWFpbHRvOnNocHJAbGliZXJvLml0XQ0KPiBTZW50OiBXZWRuZXNkYXksIE1heSAyMiwg
MjAwMiAxMjo0NyBQTQ0KPiBUbzogcG9zdGdpcy11c2Vyc0Bwb3N0Z2lzLnJlZnJhY3Rpb25z
Lm5ldA0KPiBTdWJqZWN0OiBbcG9zdGdpcy11c2Vyc10gUmU6IFtwb3N0Z2lzLXVzZXJzXSBS
ZTogUG9zdGdpcyB0b28gc2xvdw0KPiANCj4gDQo+IEV4Y3VzZSBtZSwgaGVyZSB0aGVyZSBp
cyB0aGUgcmlnaHQgbWFwIGZpbGUNCj4gDQo+ID4gU29ycnkuLi4gSSBtZWFudCB0byBzYXkg
Im1hcGZpbGUiIG5vdCAic2hhcGVmaWxlIi4uLg0KPiA+IENocmlzDQo+ID4gDQo+ID4gQ2hy
aXMgSG9kZ3NvbiB3cm90ZToNCj4gPiANCj4gPiA+IERpZCB5b3Ugc2VuZCB0aGUgd3Jvbmcg
c2hhcGVmaWxlPyBUaGVyZSBpcyBubyByZWZlcmVuY2UgaW4gdGhlcmUgdA0KbyANCj4gYSBw
b3N0Z2lzIGxheWVyLi4uDQo+ID4gPg0KPiA+ID4gQ2hyaXMNCj4gPiA+DQo+ID4gPiAic2hw
ckBsaWJlcm8uaXQiIHdyb3RlOg0KPiA+ID4NCj4gPiA+ID4gb2ssIGhlcmUgdGhlcmUgYXJl
IHRoZSBkYiBzY2hlbWEgYW5kIHRoZSAubWFwIGZpbGUuDQo+ID4gPiA+DQo+ID4gPiA+IFRo
ZSBzdHJlZXQgdGFibGUgaGF2ZSBhYm91dCA4MDAwMDAgdHVwbGVzLg0KPiA+ID4gPg0KPiA+
ID4gPiBUaGFua3MgZm9yIHlvdXIgaGVscCENCj4gPiA+ID4NCj4gPiA+ID4gU3RlZmFubw0K
PiA+ID4NCj4gPiA+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fDQo+ID4gPiBwb3N0Z2lzLXVzZXJzIG1haWxpbmcgbGlzdA0KPiA+ID4gcG9zdGdp
cy11c2Vyc0Bwb3N0Z2lzLnJlZnJhY3Rpb25zLm5ldA0KPiA+ID4gaHR0cDovL3Bvc3RnaXMu
cmVmcmFjdGlvbnMubmV0L21haWxtYW4vbGlzdGluZm8vcG9zdGdpcy11c2Vycw0KPiA+IA0K
PiA+IA0KPiA+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fDQo+ID4gcG9zdGdpcy11c2VycyBtYWlsaW5nIGxpc3QNCj4gPiBwb3N0Z2lzLXVzZXJz
QHBvc3RnaXMucmVmcmFjdGlvbnMubmV0DQo+ID4gaHR0cDovL3Bvc3RnaXMucmVmcmFjdGlv
bnMubmV0L21haWxtYW4vbGlzdGluZm8vcG9zdGdpcy11c2Vycw0KPiA+IA0KPiANCj4gX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCj4gcG9zdGdp
cy11c2VycyBtYWlsaW5nIGxpc3QNCj4gcG9zdGdpcy11c2Vyc0Bwb3N0Z2lzLnJlZnJhY3Rp
b25zLm5ldA0KPiBodHRwOi8vcG9zdGdpcy5yZWZyYWN0aW9ucy5uZXQvbWFpbG1hbi9saXN0
aW5mby9wb3N0Z2lzLXVzZXJzDQo+IA==