Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E29F7476B7A for ; Mon, 20 Jan 2003 16:40:44 -0500 (EST) Received: from pos_pdc.posportal.com (unknown [12.158.169.100]) by postgresql.org (Postfix) with ESMTP id DDEAE476CDE for ; Mon, 20 Jan 2003 16:32:41 -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 13:32:42 -0800 Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C0F@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: AcK+xLE/Sv/ROSiNRa6IWzg15iBHMgB61ut7 From: "Roman Fail" To: =?utf-8?Q?Dennis_Bj=C3=B6rklund?= Cc: "Josh Berkus" , "Stephan Szabo" , , "Tom Lane" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/209 X-Sequence-Number: 856 Pj4gSXQgc29ydCBvZiBmZWVscyBsaWtlIGEgbWFnaWMgbW9tZW50LiAgSSB3 ZW50IGJhY2sgYW5kIGxvb2tlZCB0aHJvdWdoIGENCj4+IGxvdCBvZiB0aGUg Sk9JTiBjb2x1bW5zIGFuZCBmb3VuZCB0aGF0IEkgd2FzIG1peGluZyBpbnQ0 IHdpdGggaW50OCBpbiBhDQo+PiBsb3Qgb2YgdGhlbS4NCg0KPlRoZXJlIGlz IG5vdGUgYWJvdXQgaXQgaW4gdGhlIGRvY3M6DQo+aHR0cDovL3d3dy5wb3N0 Z3Jlc3FsLm9yZy9pZG9jcy9pbmRleC5waHA/ZGF0YXR5cGUuaHRtbCNEQVRB VFlQRS1JTlQNCj4NCj5JIGRvbid0IGtub3cgaWYgdGhpcyBpcyBpbiBhIGZh cSBhbnl3aGVyZSwgYnV0IGl0IHNob3VsZCBiZS4gSSBteXNlbGYgaGF2ZQ0K PmhlbHBlZCBhIG51bWJlciBvZiBwZXJzb25zIHdpdGggdGhpcy4gRXZlcnkg b25jZSBpbiBhIHdoaWxlIHRoZXJlIGNvbWUNCj5zb21lb25lIGluIHRvIHRo ZSAjcG9zdGdyZXNxbCBpcmMgY2hhbm5lbCB3aXRoIHRoZSBleGFjdCBzYW1l IHByb2JsZW0uIA0KPlVzdWFsbHkgdGhleSBsZWF2ZSB0aGUgY2hhbm5lbCB2 ZXJ5IGhhcHB5LCB3aGVuIHRoZWlyIHF1ZXJpZXMgdGFrZSBsZXNzDQo+dGhl biBhIHNlY29uZCBpbnN0ZWFkIG9mIG1pbnV0ZXMuDQo+DQo+LS0NCj4vRGVu bmlzDQoNCkknbSByZWFsbHkgc3VycHJpc2VkIHRoYXQgdGhpcyBpc3N1ZSBk b2Vzbid0IHBvcCB1cCBhbGwgdGhlIHRpbWUuICBBcyB0aGUgY29tbXVuaXR5 IGdyb3dzLCBJIHRoaW5rIGl0IHdpbGwgc3RhcnQgdG8uICBJIGNhbWUgdmVy eSwgdmVyeSBjbG9zZSB0byBkcm9wcGluZyBQb3N0Z3JlU1FMIGVudGlyZWx5 IGJlY2F1c2Ugb2YgaXQuICBIb3BlZnVsbHkgdGhlIFRPRE8gaXNzdWUgb24g aW1wbGljaXQgdHlwZSBjYXN0aW5nIHdpbGwgbW92ZSBjbG9zZXIgdG8gdGhl IHRvcCBvZiB0aGUgaGFja2VycyBsaXN0LiAgQnV0IEknbSBqdXN0IGEgYmVn Z2FyIHNvIEkgd29uJ3QgcHJldGVuZCB0byBiZSBhIGNob29zZXIuDQogDQpC YWNrIHRvIG15IG9yaWdpbmFsIHByb2JsZW1zOiAgSSByZS1jcmVhdGVkIGV2 ZXJ5dGhpbmcgZnJvbSBzY3JhdGNoIGFuZCBtYWRlIHN1cmUgdGhlcmUgYXJl IG5vIGludDgncyBpbiBteSBlbnRpcmUgZGF0YWJhc2UuICAgSSBmb3VuZCBh IGZldyBtb3JlIHBsYWNlcyB0aGF0IEkgY291bGQgY3JlYXRlIHVzZWZ1bCBp bmRleGVzIGFzIHdlbGwuICBJIGRpZG4ndCBnZXQgdG8gdGVzdCBpdCBvdmVy IHRoZSB3ZWVrZW5kLCBidXQgdG9kYXkgSSBwbGF5ZWQgd2l0aCBpdCBmb3Ig c2V2ZXJhbCBob3VycyBhbmQgY291bGQgbm90IGdldCB0aGUgcXVlcmllcyB0 byBwZXJmb3JtIG11Y2ggYmV0dGVyIHRoYW4gbGFzdCB3ZWVrLiAgSSB3YXMg YWJvdXQgcmVhZHkgdG8gZ2l2ZSB1cCwgdGhyb3cgUG9zdGdyZXMgaW4gdGhl IGp1bmsgcGlsZSwgYW5kIGdldCBvdXQgdGhlIE1TU1FMIENELiAgDQogDQpM dWNraWx5LCBhbiB1bnJlbGF0ZWQgcG9zdCBvbiBvbmUgb2YgdGhlIGxpc3Rz IG1lbnRpb25lZCBzb21ldGhpbmcgYWJvdXQgQU5BTFlaRSwgYW5kIEkgcmVh bGl6ZWQgdGhhdCBJIGhhZCBmb3Jnb3R0ZW4gdG8gcnVuIGl0IGFmdGVyIGFs bCB0aGUgbmV3IGRhdGEgd2FzIGltcG9ydGVkIChhbHRob3VnaCBJIGRpZCBy ZW1lbWJlciBhIFZBQ1VVTSBGVUxMKS4gIEFmdGVyIHJ1bm5pbmcgQU5BTFla RSwgSSBzdGFydGVkIGdldHRpbmcgYW1hemluZyByZXN1bHRzLi4uLi5saWtl IGEgcXVlcnkgdGhhdCB0b29rIDIwIG1pbnV0ZXMgbGFzdCB3ZWVrIHdhcyB0 YWtpbmcgb25seSA2IG1pbGxpc2Vjb25kcyBub3cuICBUaGF0IGtpY2tzIHRo ZSBNU1NRTCBzZXJ2ZXIncyBhc3MgYWxsIG92ZXIgdGhlIG1hcCAoYXMgSSBo YWQgb3JpZ2luYWxseSBleHBlY3RlZCBpdCB3b3VsZCEhISkuDQogDQpTbyB0 aGluZ3MgYXJlIHdvcmtpbmcgcHJldHR5IGdvb2Qgbm93Li4uLmFuZCBpdCBs b29rcyBsaWtlIHRoZSB3aG9sZSBwcm9ibGVtIHdhcyB0aGUgZGF0YSB0eXBl IG1pc21hdGNoIGlzc3VlLiAgSSBoYXRlIHRvIHBvaW50IGZpbmdlcnMsIGJ1 dCB0aGUgcGdBZG1pbklJIE1pZ3JhdGlvbiBXaXphcmQgZm9yY2VzIGFsbCB5 b3VyIHByaW1hcnkga2V5cyB0byBiZSBpbnQ4IGV2ZW4gaWYgeW91IHNldCB0 aGUgVHlwZSBNYXAgdG8gaW50NC4gIFRoZSBzZWNvbmQgdGltZSB0aHJvdWdo IEkgcmVjb2duaXplZCB0aGlzIGFuZCBkaWQgYSBwZ19kdW1wIHNvIEkgY291 bGQgc3dpdGNoIGV2ZXJ5dGhpbmcgdG8gaW50NC4gIE5vdyBJJ20gZ29pbmcg dG8gd3JpdGUgc29tZSBtaW5vciBtb2RzIGluIG15IEphdmEgcHJvZ3JhbXMg Zm9yIFBHU1FMLXN5bnRheCBjb21wYXRpYmlsaXR5LCBhbmQgd2lsbCBob3Bl ZnVsbHkgaGF2ZSB0aGUgUG9zdGdyZVNRTCBzZXJ2ZXIgaW4gcHJvZHVjdGlv biBzaG9ydGx5LiAgDQogDQpUSEFOSyBZT1UgdG8gZXZlcnlvbmUgb24gcGdz cWwtcGVyZm9ybWFuY2UgZm9yIGFsbCB5b3VyIGhlbHAuICBZb3UgYXJlIHRo ZSByZWFzb24gdGhhdCBJJ2xsIGJlIGEgbG9uZyB0ZXJtIG1lbWJlciBvZiB0 aGUgUG9zdGdyZXMgY29tbXVuaXR5LiAgSSBob3BlIHRoYXQgSSBjYW4gYXNz aXN0IHNvbWVvbmUgZWxzZSBvdXQgaW4gdGhlIGZ1dHVyZS4gIA0KIA0KUm9t YW4gRmFpbA0KU3IuIFdlYiBBcHBsaWNhdGlvbiBEZXZlbG9wZXINClBPUyBQ b3J0YWwsIEluYy4NCiANCiANCg==