Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 299CD476543 for ; Fri, 17 Jan 2003 00:54:36 -0500 (EST) Received: from pos_pdc.posportal.com (unknown [12.158.169.100]) by postgresql.org (Postfix) with ESMTP id 301D947651E for ; Fri, 17 Jan 2003 00:54:34 -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: Thu, 16 Jan 2003 21:54:39 -0800 Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C09@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: AcK9l/wPnT5XK39ZSQKMu5my8Z07QgAKAnUG From: "Roman Fail" To: "Tom Lane" Cc: "Josh Berkus" , , X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/171 X-Sequence-Number: 818 VG9tIGFuZCBUb21hc3o6DQpJIGhhdmUgdG8gY2hhbmdlIHRoZSBkYXRhdHlw ZSBvZiBiYXRjaGRldGFpbC5iYXRjaGlkIGZyb20gaW50NCB0byBpbnQ4LiAg QWZ0ZXIgb3ZlciA0IGhvdXJzLCB0aGUgVVBEQVRFIHRyYW5zZmVyIGZyb20g dGhlIG9sZCBjb2x1bW4gdG8gbmV3IGhhcyBub3QgeWV0IGNvbXBsZXRlZC4g IEFmdGVyIHRoYXQgSSBzdGlsbCBoYXZlIHRvIGJ1aWxkIGEgbmV3IGluZGV4 IGFuZCBydW4gVkFDVVVNIEZVTEwuICBXaGVuIHRoYXQgaXMgYWxsIGRvbmUg SSdsbCByZS1ydW4gdGhlIHZhcmlvdXMgcXVlcmllcywgaW5jbHVkaW5nIGEg c3BlY2lmaWMgc21hbGwgb25lIHRoYXQgSm9zaCByZXF1ZXN0ZWQuICANCiAN CkNoYWQgVGhvbXBzb24gc3VnZ2VzdGVkIHRoYXQgSSBhZGQgc2luZ2xlIHF1 b3RlcyBhcm91bmQgdGhlIGxpdGVyYWxzIGluIHRoZSBXSEVSRSBjbGF1c2Us IHdoaWNoIHNvdW5kZWQgbGlrZSBhIGdyZWF0IGlkZWEgYmFzZWQgb24gaGlz IGV4cGVyaWVuY2UuICBVbmZvcnR1bmF0ZWx5LCBpdCBkaWQgbm90IG1ha2Ug dGhlIHF1ZXJ5IGFueSBmYXN0ZXIuICBCdXQgcmVhZCBvbiENCiANCkZvciBr aWNrcywgSSB0cmllZCB0aGlzIHNpbXBsZSBxdWVyeSwgd2hpY2ggc2hvdWxk IGhhcHBlbiBpbiBhbiBpbnN0YW50LiAgSXQgaXMgdGhlIGZpcnN0IHJvdyBp biB0aGUgdGFibGUuDQpFWFBMQUlOIEFOQUxZWkUgc2VsZWN0IGJhdGNoZGV0 YWlsaWQgZnJvbSBiYXRjaGRldGFpbCB3aGVyZSBiYXRjaGRldGFpbGlkID0g MjczMjE7DQogU2VxIFNjYW4gb24gYmF0Y2hkZXRhaWwgIChjb3N0PTAuMDAu LjE5NjA0ODUuNDMgcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGltZT0xNy41 OC4uMjY0MzAzLjc2IHJvd3M9MSBsb29wcz0xKQ0KICAgRmlsdGVyOiAoYmF0 Y2hkZXRhaWxpZCA9IDI3MzIxKQ0KIFRvdGFsIHJ1bnRpbWU6IDI2NDMwMy44 NyBtc2VjDQpEb2VzIGl0IG1ha2Ugc2Vuc2UgdG8gZG8gYSBzZXF1ZW5jZSBz Y2FuIHdoZW4gdGhlIHByaW1hcnkga2V5IGluZGV4IGlzIGF2YWlsYWJsZT8g IEV2ZW4gc28sIGl0J3Mgc3RpbGwgYSBwcmV0dHkgaG9ycmlibGUgdGltZSBn aXZlbiB0aGUgaGFyZHdhcmUuDQogDQpIT1dFVkVSLi4uLi5sb29rIGF0IHRo aXM6DQpFWFBMQUlOIEFOQUxZWkUgc2VsZWN0IGJhdGNoZGV0YWlsaWQgZnJv bSBiYXRjaGRldGFpbCB3aGVyZSBiYXRjaGRldGFpbGlkID0gMjczMjE6OmJp Z2ludDsNCiBJbmRleCBTY2FuIHVzaW5nIGJhdGNoZGV0YWlsX3BrZXkgb24g YmF0Y2hkZXRhaWwgIChjb3N0PTAuMDAuLjQuMTMgcm93cz0xIHdpZHRoPTgp IChhY3R1YWwgdGltZT0wLjAzLi4wLjAzIHJvd3M9MSBsb29wcz0xKQ0KICAg SW5kZXggQ29uZDogKGJhdGNoZGV0YWlsaWQgPSAyNzMyMTo6YmlnaW50KQ0K IFRvdGFsIHJ1bnRpbWU6IDAuMDcgbXNlYw0KIA0KSXQgc29ydCBvZiBmZWVs cyBsaWtlIGEgbWFnaWMgbW9tZW50LiAgSSB3ZW50IGJhY2sgYW5kIGxvb2tl ZCB0aHJvdWdoIGEgbG90IG9mIHRoZSBKT0lOIGNvbHVtbnMgYW5kIGZvdW5k IHRoYXQgSSB3YXMgbWl4aW5nIGludDQgd2l0aCBpbnQ4IGluIGEgbG90IG9m IHRoZW0uICBBbGwgb2YgdGhlc2UgdGFibGVzIChleGNlcHQgYmF0Y2hkZXRh aWwpIHdlcmUgbWlncmF0ZWQgdXNpbmcgcGdBZG1pbklJJ3MgbWlncmF0aW9u IHdpemFyZCwgc28gSSBkaWRuJ3QgcmVhbGx5IGdpdmUgYSBoYXJkIGxvb2sg YXQgYWxsIHRoZSBkYXRhIHR5cGVzIG1hdGNoaW5nIHVwIHNpbmNlIGl0IGhh cyBhIG5pY2UgZGF0YSBtYXAgKEkgdXNlZCB0aGUgZGVmYXVsdHMgZXhjZXB0 IGZvciB0aGUgbW9uZXkgdHlwZSkuICANCiANCk5vdyBJIHRoaW5rIEknbSBq dXN0IGdvaW5nIHRvIGRyb3AgdGhlIGVudGlyZSBkYXRhYmFzZSBhbmQgcmVs b2FkIHRoZSBkYXRhIGZyb20gc2NyYXRjaCwgbWFraW5nIHN1cmUgdGhhdCB0 aGUgZGF0YSB0eXBlcyBhcmUgbWFwcGVkIGV4YWN0bHkgcmlnaHQuICBDb3Jy ZWN0IG1lIGlmIEknbSB3cm9uZywgYnV0IGludDQgb25seSByYW5nZXMgZnJv bSBuZWdhdGl2ZSAyIGJpbGxpb24gdG8gcG9zaXRpdmUgMiBiaWxsaW9uLiAg QWxsIHRoZSBwcmltYXJ5IGtleXMgZm9yIG15IHRhYmxlcyB3b3VsZCBmaXQg aW4gdGhpcyByYW5nZSB3aXRoIHRoZSBleGNlcHRpb24gb2YgYmF0Y2hkZXRh aWwsIHdoaWNoIGNvdWxkIGNvbmNlaXZhYmx5IGdyb3cgYmV5b25kIDIgYmls bGlvbiBzb21lZGF5IChhbHRob3VnaCBJJ2QgYmUgYXJjaGl2aW5nIGEgbG90 IG9mIGl0IHdoZW4gaXQgZ290IHRoYXQgYmlnKS4gIE1heWJlIEkganVzdCBz aG91bGRuJ3Qgd29ycnkgYWJvdXQgaXQgZm9yIG5vdyBhbmQgbWFrZSBldmVy eXRoaW5nIGludDQgZm9yIHNpbXBsaWNpdHkuDQogDQpJIGRvdWJ0IEkgd2ls bCBhY2NvbXBsaXNoIGFsbCB0aGlzIG9uIEZyaWRheSwgYnV0IEknbGwgZ2l2 ZSBhIGZ1bGwgcmVwb3J0IG9uY2UgSSBnZXQgaXQgYWxsIHJlbG9hZGVkLiAN CiANCj4gU3RlcGhhbiBTemFibyB3cm90ZToNCj4gQWxzbyB5b3UgaGF2ZSB0 d28gaW5kZXhlcyBvbiBiYXRjaGRldGFpbGlkIHJpZ2h0IG5vdyAocHJpbWFy eSBrZXkNCj4gYWxzbyBjcmVhdGVzIG9uZSkgd2hpY2ggYWRkZWQgdG8gdGhl IGNvbmZ1c2lvbi4NCg0KVGhlIDcuMy4xIGRvY3MgZm9yIENSRUFURSBUQUJM RSBkb24ndCBtZW50aW9uIGFueXRoaW5nIGFib3V0IGF1dG9tYXRpYyBpbmRl eCBjcmVhdGlvbiBmb3IgYSBQUklNQVJZIEtFWS4gIEkgZGlkbid0IHNlZSBh bnkgUEsgaW5kZXhlcyB2aWEgcGdBZG1pbklJLCBzbyBJIHJlYWQgdGhpcyBs aW5lIGZyb20gdGhlIGRvY3MgYW5kIGRlY2lkZWQgdG8gY3JlYXRlIHRoZW0g c2VwYXJhdGVseS4NCiAgICAiVGVjaG5pY2FsbHksIFBSSU1BUlkgS0VZIGlz IG1lcmVseSBhIGNvbWJpbmF0aW9uIG9mIFVOSVFVRSBhbmQgTk9UIE5VTEwi DQpIb3dldmVyLCB0aGlzIHF1ZXJ5IHByb3ZlcyB5b3UgYXJlIHJpZ2h0Og0K dHJhbnM9IyBzZWxlY3QgcmVsbmFtZSwgcmVscGFnZXMsIGluZGlzdW5pcXVl LCBpbmRpc3ByaW1hcnkgZnJvbSBwZ19jbGFzcywgcGdfaW5kZXgNCnRyYW5z LSMgd2hlcmUgaW5kZXhyZWxpZCBpbiAoMzcxMjY3MzksIDg2MDQyNTcpIGFu ZCBwZ19jbGFzcy5vaWQgPSBwZ19pbmRleC5pbmRleHJlbGlkOw0KIHJlbG5h bWUgICAgICAgICAgICAgICAgICAgICAgICAgIHwgcmVscGFnZXMgfCBpbmRp c3VuaXF1ZSB8IGluZGlzcHJpbWFyeQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0t LS0tLS0tLS0NCiBiYXRjaGRldGFpbF9wa2V5ICAgICAgICAgICAgICAgICB8 ICAgMTIxODUwIHwgdCAgICAgICAgICAgfCB0DQogYmF0Y2hkZXRhaWxfaXhf YmF0Y2hkZXRhaWxpZF9pZHggfCAgICA2MzkzNCB8IGYgICAgICAgICAgIHwg Zg0KIA0KQWxsIG90aGVyIGNvbHVtbnMgaW4gdGhlIHR3byB0YWJsZXMgYXJl IGlkZW50aWNhbCBmb3IgdGhlc2UgdHdvIGluZGV4ZXMuICBTbyBub3cgSSd2 ZSBnb25lIHRocm91Z2ggYW5kIGRlbGV0ZWQgYWxsIG9mIHRoZXNlIGR1cGxp Y2F0ZSBpbmRleGVzIEkgY3JlYXRlZCAoYW5kIHRoZW4gYSBWQUNVVU0gRlVM TCkuICBQZXJoYXBzIGFuIGV4dHJhIHNlbnRlbmNlIGluIHRoZSBkb2NzIG1p Z2h0IHByZXZlbnQgc29tZW9uZSBlbHNlIGZyb20gbWFraW5nIHRoZSBzYW1l IG1pc3Rha2UgYXMgST8NCiANCioqKiBDdXJyZW50IHBvc3RncmVzcWwuY29u ZiBzZXR0aW5nczoNCnRjcGlwX3NvY2tldD10cnVlDQpzaGFyZWRfYnVmZmVy cyA9IDEzMTA3Mg0KbWF4X2ZzbV9yZWxhdGlvbnMgPSAxMDAwMA0KbWF4X2Zz bV9wYWdlcyA9IDIwMDAwMDANCnNvcnRfbWVtID0gMzI3NjgNCmRlZmF1bHRf c3RhdGlzdGljc190YXJnZXQgPSAzMA0KDQpUaGFua3MgYWdhaW4gZm9yIGFs bCB5b3VyIGhlbHAhDQogDQpSb21hbiBGYWlsDQpTci4gV2ViIEFwcGxpY2F0 aW9uIERldmVsb3Blcg0KUE9TIFBvcnRhbCwgSW5jLg0KIA0K