Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7EECE4763AE for ; Fri, 17 Jan 2003 09:49:11 -0500 (EST) Received: from pos_pdc.posportal.com (unknown [12.158.169.100]) by postgresql.org (Postfix) with ESMTP id 6DF6147721D for ; Fri, 17 Jan 2003 09:48:29 -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: Implicit casting and JOIN syntax constraints Date: Fri, 17 Jan 2003 06:48:28 -0800 Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C0B@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+MMt5Ej1+jTmlTVq88jlphHkjhwABVroz From: "Roman Fail" To: "Jeff" Cc: "Tom Lane" , "Josh Berkus" , , X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/177 X-Sequence-Number: 824 Pj4gSE9XRVZFUi4uLi4ubG9vayBhdCB0aGlzOg0KPj4gRVhQTEFJTiBBTkFM WVpFIHNlbGVjdCBiYXRjaGRldGFpbGlkIGZyb20gYmF0Y2hkZXRhaWwgd2hl cmUgYmF0Y2hkZXRhaWxpZCA9IDI3MzIxOjpiaWdpbnQ7DQo+PiAgSW5kZXgg U2NhbiB1c2luZyBiYXRjaGRldGFpbF9wa2V5IG9uIGJhdGNoZGV0YWlsICAo Y29zdD0wLjAwLi40LjEzIHJvd3M9MSB3aWR0aD04KSAoYWN0dWFsIHRpbWU9 MC4wMy4uMC4wMyByb3dzPTEgbG9vcHM9MSkNCj4+ICAgIEluZGV4IENvbmQ6 IChiYXRjaGRldGFpbGlkID0gMjczMjE6OmJpZ2ludCkNCj4+ICBUb3RhbCBy dW50aW1lOiAwLjA3IG1zZWMNCg0KPiBKZWZmIFRyb3V0IHdyb3RlOg0KPiBX ZSBoYWQgdGhpcyBoYXBwZW4gdG8gdXMgLSB3ZSBoYWQgYSBzZXJpYWw4IGNv bHVtbiAoaW50OCkgYW5kIG91ciBxdWVyeQ0KPiB3YXMgc3RyYWlnaHQgZm9y d2FyZCB3aGVyZSBpZCA9IDEyMzQ1OyB3aGljaCByYW4gY3JhcHRhY3VsYXJs eS4gIEFmdGVyDQo+IG11Y2ggaGVhZCBiYW5naW5nIGFuZCBjdXJzaW5nIEkg aGFkIHRyaWVkIHdoZXJlIGlkID0gJzEyMzQ1JyBhbmQgaXQNCj4gbWFnaWNh bGx5IHdvcmtlZC4gSSB0aGluayB0aGUgcGFyc2VyIGlzIGludGVycHJldGlu ZyBhICJudW1iZXIiIHRvIGJlIGFuDQo+IGludDQgaW5zdGVhZCBvZiBpbnQ4 LiAgKGluc3RlYWQgb2YgcXVvdGVzIHlvdSBjYW4gYWxzbyBjYXN0IHZpYQ0K PiAxMjM0NTo6aW50OCBsaWtlIHlvdSBkaWQpDQoNCj4gUGVyaGFwcyB0aGlz IHNob3VsZCBnbyBvbiB0aGUgVE9ETyAtIHdoZW4gb25lIHNpZGUgaXMgYW4g aW50OCBhbmQgdGhlDQo+IG90aGVyIGlzIGEgbGl0ZXJhbCBudW1iZXIgYXNz dW1lIHRoZSBudW1iZXIgdG8gYmUgaW50OCBpbnN0ZWFkIG9mIGludDQ/DQoN Ckl0IHNlZW1zIHRvIG1lIHRoYXQgdGhpcyBzaG91bGQgYWJzb2x1dGVseSBn byBvbiB0aGUgVE9ETyBsaXN0LiAgV2h5IGRvZXMgdGhlIHBsYW5uZXIgcmVx dWlyZSBhbiBleHBsaWNpdCBjYXN0IHdoZW4gdGhlIGltcGxpY2l0IGNhc3Qg aXMgc28gb2J2aW91cz8gIERvZXMgT3JhY2xlIGRvIHRoaXM/ICBJIGNhbiBh c3N1cmUgeW91IHRoYXQgTVNTUUwgZG9lcyBub3QuICANCiANCklmIGdldHRp bmcgbW9yZSBwZW9wbGUgdG8gbWlncmF0ZSB0byBQb3N0Z3JlU1FMIGlzIGEg bWFqb3IgZ29hbCB0aGVzZSBkYXlzLCBpdCdzIGdvdCB0byBiZSByZWxhdGl2 ZWx5IGVhc3kuICBJIHRoaW5rIHRoYXQgYWxtb3N0IGV2ZXJ5b25lIGNvbWlu ZyBmcm9tIGEgTVNTUUwgb3IgQWNjZXNzIGJhY2tncm91bmQgaXMgZ29pbmcg dG8gaGF2ZSBiaWcgcHJvYmxlbXMgd2l0aCB0aGlzLiAgQW5kIHRoZSBvdGhl ciBpc3N1ZSBvZiB0aGUgSk9JTiBzeW50YXggY29uc3RyYWluaW5nIHRoZSBw bGFubmVyIC0geW91J3ZlIGdvdCB0byBiZSBhYmxlIHRvIHR1cm4gdGhhdCBv ZmYgdG9vLiAgSSd2ZSBiZWVuIHdyaXRpbmcgU1FMIHF1ZXJpZXMgZm9yIDEw IHllYXJzIGluIEZveFBybywgQWNjZXNzLCBTUUwgU2VydmVyLCBNeVNRTCwg YW5kIFN5YmFzZS4gIEkgaGF2ZSBuZXZlciBjb21lIGFjcm9zcyB0aGlzIHZl cnkgY29uZnVzaW5nICJmZWF0dXJlIiB1bnRpbCBub3cuICANCiANCkhvdyBk byB3ZSBnbyBhYm91dCB2b3RpbmcgYW4gaXNzdWUgb250byB0aGUgVE9ETyBs aXN0PyAgVGhlc2UgdHdvIGdldCBteSB2b3RlIGZvciBzdXJlIQ0KIA0KUm9t YW4NCg==