Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 373FE4764EB for ; Mon, 20 Jan 2003 17:33:49 -0500 (EST) Received: from pos_pdc.posportal.com (unknown [12.158.169.100]) by postgresql.org (Postfix) with ESMTP id BA6E54768AC for ; Mon, 20 Jan 2003 17:33:23 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Subject: Re: 7.3.1 New install, large queries are slow Date: Mon, 20 Jan 2003 14:33:25 -0800 Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C11@pos_pdc.posportal.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] 7.3.1 New install, large queries are slow Thread-Index: AcLAzrojSfxhtVV6SFKZ2/vr+e/ZegAAziiJ From: "Roman Fail" To: X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/211 X-Sequence-Number: 858 PiBKb2NoZW0gdmFuIERpZXRlbiB3cm90ZToNCj4gSnVzdCBvdXQgb2YgY3Vy aW9zaXR5IGFuZCBmb3IgYXJjaGl2aW5nIHB1cnBvc2VzLCBjb3VsZCB5b3Ug cG9zdCB0aGUgbmV3DQo+IEVYUExBSU4gQU5BTFlaRSBvdXRwdXQgdG8gdGhl IGxpc3Q/DQoNClRvIHJlaXRlcmF0ZSwgdGhlIGJhdGNoZGV0YWlsIHRhYmxl IGlzIDI0IG1pbGxpb24gcm93cywgYmF0Y2hoZWFkZXIgaXMgMi43IG1pbGxp b24sIGFuZCBwdXJjMSBpcyAxIG1pbGxpb24uICBUaGUgcmVzdCBhcmUgMjAw MCByb3dzIG9yIGxlc3MuICBJIHRoaW5rIGhhdmluZyB0aGUgNi1kaXNrIFJB SUQtMTAgZGV2b3RlZCB0byAvdXNyL2xvY2FsL3Bnc3FsL2RhdGEgaGVscHMg b3V0IGEgbGl0dGxlIGhlcmUuICAgSSBkaWQgdHJ5IGNoYW5naW5nIHRoZSBX SEVSRSBjbGF1c2VzIHRvIHJhZGljYWxseSBkaWZmZXJlbnQgdmFsdWVzIGFu ZCBpdCB3YXMgc3RpbGwganVzdCBhcyBmYXN0LiAgVGhpcyBpcyB0aGUgb3Jp Z2luYWwgcXVlcnkgSSB3YXMgd29ya2luZyB3aXRoIChwbHVzIHN1Z2dlc3Rl ZCBtb2RpZmljYXRpb25zIGZyb20gdGhlIGxpc3QpOg0KDQpFWFBMQUlOIEFO QUxZWkUNClNFTEVDVCBzcy5iYXRjaGRhdGUsIHNzLmJhdGNoZGV0YWlsaWQs IHNzLmJhbmtubywgc3MudHJhbmRhdGUsIHNzLnRyYW5hbW91bnQsDQpzcy5z dWJtaXRpbnRlcmNoYW5nZSwgc3MuYXV0aGFtb3VudCwgc3MuYXV0aG5vLCBz cy5jYXJkdHlwZWlkLCBzcy5tY2Njb2RlLA0Kc3MubmFtZSBBUyBtZXJjaGFu dG5hbWUsIHNzLmNhcmR0eXBlLCBzcy5tZXJjaGlkLA0KcDEubG9jYWx0YXhh bW91bnQsIHAxLnByb2R1Y3RpZGVudGlmaWVyLCBkci5hdnNyZXNwb25zZSwN CmNyLmNoZWNrb3V0ZGF0ZSwgY3Iubm9zaG93aW5kaWNhdG9yLCBjay5jaGVj a2luZ2FjY3RubywNCmNrLmFiYXJvdXRpbmdubywgY2suY2hlY2tubw0KRlJP TQ0KICAoU0VMRUNUIGIuYmF0Y2hkYXRlLCBkLmJhdGNoZGV0YWlsaWQsIHQu YmFua25vLCBkLnRyYW5kYXRlLCBkLnRyYW5hbW91bnQsDQogICAgICAgZC5z dWJtaXRpbnRlcmNoYW5nZSwgZC5hdXRoYW1vdW50LCBkLmF1dGhubywgZC5j YXJkdHlwZWlkLCBkLm1jY2NvZGUsDQogICAgICAgbS5uYW1lLCBjLmNhcmR0 eXBlLCBtLm1lcmNoaWQNCiAgIEZST00gdHJhbmhlYWRlciB0LCBiYXRjaGhl YWRlciBiLCBtZXJjaGFudHMgbSwgY2FyZHR5cGUgYywgYmF0Y2hkZXRhaWwg ZA0KICAgV0hFUkUgdC50cmFuaGVhZGVyaWQ9Yi50cmFuaGVhZGVyaWQNCiAg IEFORCBtLm1lcmNoYW50aWQ9Yi5tZXJjaGFudGlkDQogICBBTkQgZC5iYXRj aGlkPWIuYmF0Y2hpZA0KICAgQU5EIGMuY2FyZHR5cGVpZD1kLmNhcmR0eXBl aWQNCiAgIEFORCB0LmNsaWVudGlkID0gNg0KICAgQU5EIGQudHJhbmFtb3Vu dCBCRVRXRUVOIDUwMC4wIEFORCA3MDAuMA0KICAgQU5EIGIuYmF0Y2hkYXRl ID4gJzIwMDItMTItMTUnDQogICBBTkQgbS5tZXJjaGlkID0gJzcwMTI1MjI2 NycpIHNzDQogIExFRlQgSk9JTiBwdXJjMSBwMSBvbiBwMS5iYXRjaGRldGFp bGlkPXNzLmJhdGNoZGV0YWlsaWQNCiAgTEVGVCBKT0lOIGRpcmVjdCBkciBP TiBkci5iYXRjaGRldGFpbGlkID0gc3MuYmF0Y2hkZXRhaWxpZA0KICBMRUZU IEpPSU4gY2FycmVudGFsIGNyIE9OIGNyLmJhdGNoZGV0YWlsaWQgPSBzcy5i YXRjaGRldGFpbGlkDQogIExFRlQgSk9JTiBjaGVja3MgY2sgT04gY2suYmF0 Y2hkZXRhaWxpZCA9IHNzLmJhdGNoZGV0YWlsaWQNCk9SREVSIEJZIHNzLmJh dGNoZGF0ZSBERVNDDQpMSU1JVCA1MA0KDQpMaW1pdCAgKGNvc3Q9MTM1MS45 My4uMTM1MS45MyByb3dzPTEgd2lkdGg9MjYxKSAoYWN0dWFsIHRpbWU9NS4z NC4uNS4zNiByb3dzPTggbG9vcHM9MSkNCiAgLT4gIFNvcnQgIChjb3N0PTEz NTEuOTMuLjEzNTEuOTMgcm93cz0xIHdpZHRoPTI2MSkgKGFjdHVhbCB0aW1l PTUuMzMuLjUuMzQgcm93cz04IGxvb3BzPTEpDQogICAgICAgIFNvcnQgS2V5 OiBiLmJhdGNoZGF0ZQ0KICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0 PTAuMDEuLjEzNTEuOTIgcm93cz0xIHdpZHRoPTI2MSkgKGFjdHVhbCB0aW1l PTEuNjEuLjUuMjQgcm93cz04IGxvb3BzPTEpDQogICAgICAgICAgICAgIC0+ ICBIYXNoIEpvaW4gIChjb3N0PTAuMDEuLjEzNDYuOTkgcm93cz0xIHdpZHRo PTIyMykgKGFjdHVhbCB0aW1lPTEuNTguLjUuMDYgcm93cz04IGxvb3BzPTEp DQogICAgICAgICAgICAgICAgICAgIEhhc2ggQ29uZDogKCJvdXRlciIuYmF0 Y2hkZXRhaWxpZCA9ICJpbm5lciIuYmF0Y2hkZXRhaWxpZCkNCiAgICAgICAg ICAgICAgICAgICAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9MC4wMC4uMTM0Ni45 OCByb3dzPTEgd2lkdGg9MjEwKSAoYWN0dWFsIHRpbWU9MS4yMS4uNC41OCBy b3dzPTggbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgSGFz aCBDb25kOiAoIm91dGVyIi5iYXRjaGRldGFpbGlkID0gImlubmVyIi5iYXRj aGRldGFpbGlkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVz dGVkIExvb3AgIChjb3N0PTAuMDAuLjEzNDYuOTcgcm93cz0xIHdpZHRoPTIw MSkgKGFjdHVhbCB0aW1lPTAuODIuLjQuMDUgcm93cz04IGxvb3BzPTEpDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9v cCAgKGNvc3Q9MC4wMC4uMTM0My44NCByb3dzPTEgd2lkdGg9MTgyKSAoYWN0 dWFsIHRpbWU9MC43OC4uMy44MiByb3dzPTggbG9vcHM9MSkNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6ICgi aW5uZXIiLmNhcmR0eXBlaWQgPSAib3V0ZXIiLmNhcmR0eXBlaWQpDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQg TG9vcCAgKGNvc3Q9MC4wMC4uMTM0Mi42MiByb3dzPTEgd2lkdGg9MTcyKSAo YWN0dWFsIHRpbWU9MC43NC4uMy4zNSByb3dzPTggbG9vcHM9MSkNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5l c3RlZCBMb29wICAoY29zdD0wLjAwLi41MzkuMzIgcm93cz00IHdpZHRoPTEw NikgKGFjdHVhbCB0aW1lPTAuMTcuLjEuNjEgcm93cz0yNiBsb29wcz0xKQ0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjUxNS40OCByb3dz PTUgd2lkdGg9OTQpIChhY3R1YWwgdGltZT0wLjEzLi4xLjAxIHJvd3M9MjYg bG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgbWVy Y2hhbnRzX2l4X21lcmNoaWRfaWR4IG9uIG1lcmNoYW50cyBtICAoY29zdD0w LjAwLi41LjY1IHJvd3M9MSB3aWR0aD03OCkgKGFjdHVhbCB0aW1lPTAuMDcu LjAuMDggcm93cz0xIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4 IENvbmQ6IChtZXJjaGlkID0gJzcwMTI1MjI2Nyc6OmNoYXJhY3RlciB2YXJ5 aW5nKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBiYXRjaGhl YWRlcl9peF9tZXJjaGFudGlkX2lkeCBvbiBiYXRjaGhlYWRlciBiICAoY29z dD0wLjAwLi41MDguNTYgcm93cz0yMCB3aWR0aD0xNikgKGFjdHVhbCB0aW1l PTAuMDQuLjAuODEgcm93cz0yNiBsb29wcz0xKQ0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICBJbmRleCBDb25kOiAoIm91dGVyIi5tZXJjaGFudGlkID0gYi5tZXJjaGFu dGlkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChiYXRjaGRhdGUgPiAn MjAwMi0xMi0xNSc6OmRhdGUpDQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5n IHRyYW5oZWFkZXJfcGtleSBvbiB0cmFuaGVhZGVyIHQgIChjb3N0PTAuMDAu LjUuMDggcm93cz0xIHdpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wMS4uMC4w MSByb3dzPTEgbG9vcHM9MjYpDQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0 LnRyYW5oZWFkZXJpZCA9ICJvdXRlciIudHJhbmhlYWRlcmlkKQ0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBGaWx0ZXI6IChjbGllbnRpZCA9IDYpDQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVz aW5nIGJhdGNoZGV0YWlsX2l4X2JhdGNoaWRfaWR4IG9uIGJhdGNoZGV0YWls IGQgIChjb3N0PTAuMDAuLjE4Ni44MSByb3dzPTIgd2lkdGg9NjYpIChhY3R1 YWwgdGltZT0wLjA1Li4wLjA2IHJvd3M9MCBsb29wcz0yNikNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5k ZXggQ29uZDogKGQuYmF0Y2hpZCA9ICJvdXRlciIuYmF0Y2hpZCkNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg RmlsdGVyOiAoKHRyYW5hbW91bnQgPj0gNTAwLjApIEFORCAodHJhbmFtb3Vu dCA8PSA3MDAuMCkpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIC0+ICBTZXEgU2NhbiBvbiBjYXJkdHlwZSBjICAoY29zdD0wLjAw Li4xLjEwIHJvd3M9MTAgd2lkdGg9MTApIChhY3R1YWwgdGltZT0wLjAwLi4w LjAzIHJvd3M9MTAgbG9vcHM9OCkNCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgcHVyYzFfaXhfYmF0Y2hk ZXRhaWxpZF9pZHggb24gcHVyYzEgcDEgIChjb3N0PTAuMDAuLjMuMTIgcm93 cz0xIHdpZHRoPTE5KSAoYWN0dWFsIHRpbWU9MC4wMS4uMC4wMSByb3dzPTAg bG9vcHM9OCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgSW5kZXggQ29uZDogKHAxLmJhdGNoZGV0YWlsaWQgPSAib3V0ZXIiLmJh dGNoZGV0YWlsaWQpDQogICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBI YXNoICAoY29zdD0wLjAwLi4wLjAwIHJvd3M9MSB3aWR0aD05KSAoYWN0dWFs IHRpbWU9MC4wMC4uMC4wMCByb3dzPTAgbG9vcHM9MSkNCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGRpcmVjdCBk ciAgKGNvc3Q9MC4wMC4uMC4wMCByb3dzPTEgd2lkdGg9OSkgKGFjdHVhbCB0 aW1lPTAuMDAuLjAuMDAgcm93cz0wIGxvb3BzPTEpDQogICAgICAgICAgICAg ICAgICAgIC0+ICBIYXNoICAoY29zdD0wLjAwLi4wLjAwIHJvd3M9MSB3aWR0 aD0xMykgKGFjdHVhbCB0aW1lPTAuMDEuLjAuMDEgcm93cz0wIGxvb3BzPTEp DQogICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBj YXJyZW50YWwgY3IgIChjb3N0PTAuMDAuLjAuMDAgcm93cz0xIHdpZHRoPTEz KSAoYWN0dWFsIHRpbWU9MC4wMC4uMC4wMCByb3dzPTAgbG9vcHM9MSkNCiAg ICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgY2hlY2tzX2l4X2Jh dGNoZGV0YWlsaWRfaWR4IG9uIGNoZWNrcyBjayAgKGNvc3Q9MC4wMC4uNC45 MiByb3dzPTEgd2lkdGg9MzgpIChhY3R1YWwgdGltZT0wLjAxLi4wLjAxIHJv d3M9MCBsb29wcz04KQ0KICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25k OiAoY2suYmF0Y2hkZXRhaWxpZCA9ICJvdXRlciIuYmF0Y2hkZXRhaWxpZCkN ClRvdGFsIHJ1bnRpbWU6IDUuODkgbXNlYw0KDQoNCg==