X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 21BCBCC88F for ; Thu, 17 Jul 2003 04:25:42 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 35392-10 for ; Thu, 17 Jul 2003 04:25:59 +0000 (GMT) Received: from pos_pdc.posportal.com (unknown [12.158.169.100]) by svr1.postgresql.org (Postfix) with ESMTP id 7A0ADCC886 for ; Thu, 17 Jul 2003 01:25:30 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Subject: Re: Hardware performance Date: Wed, 16 Jul 2003 21:25:43 -0700 Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCA3@pos_pdc.posportal.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] Hardware performance Thread-Index: AcNMDzqIhh5+uYI3QA6yk4RNVGBPvgACDyAP From: "Roman Fail" To: "Balazs Wellisch" , X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/240 X-Sequence-Number: 2533 SSd2ZSBnb3QgYSBEZWxsIDI2NTAgc2V0IHVwIHdpdGggNSBkcml2ZXMgYW5k IGEgc2VwYXJhdGUgYXBwIHNlcnZlciBjb25uZWN0aW5nIHdpdGggSkRCQy4g IFNpbmNlIHlvdSd2ZSBvbmx5IGdvdCA1IGRyaXZlcywgbXkgY29uY2x1c2lv biByZWdhcmRpbmcgdGhlIGJlc3QgYmFsYW5jZSBvZiBwZXJmb3JtYW5jZSBh bmQgcmVkdW5kYW5jeSB3YXM6DQogDQoyIGRyaXZlcyBoYXZlIHRoZSBPUywg c3dhcCwgYW5kIFdBTCBpbiBSQUlELTENCjMgZHJpdmVzIGhhdmUgdGhlIGRh dGEgaW4gUkFJRC01DQogDQpJZiB5b3UgY2FuIGFmZm9yZCBpdCwgZ2V0IHRo ZSAyKzMgc3BsaXQgYmFja3BsYW5lIGFuZCBtYWtlIHRoZSAzIGRhdGEgZHJp dmVzIHRoZSBiaWdnZXN0LCBmYXN0ZXN0IHlvdSBjYW4gYWZmb3JkLiAgQ3Vy cmVudGx5IHRoYXQgbWVhbnMgdGhlIDE1ayA3M0dCIGRyaXZlcywgd2hpY2gg d291bGQgZ2l2ZSB5b3UgMTQ2R0IgZm9yIGRhdGEuICBNYWtlIHRoZSBPUyBk cml2ZXMgc21hbGxlciBhbmQgc2xvd2VyIGlmIHlvdSBuZWVkIHRvIHNhdmUg Y2FzaC4gIA0KIA0KSWYgb25seSBpdCBoYWQgc2l4IGRyaXZlIGJheXMuLi4u eW91IGNvdWxkIHVzZSA0IGRyaXZlcyBmb3IgdGhlIGRhdGEgYW5kIGRvIFJB SUQtMTAuICBJZiB5b3UndmUgZ290IHRoZSBhZGRpdGlvbmFsIHJhY2tzcGFj ZSBhdmFpbGFibGUsIHlvdSBjb3VsZCBnZXQgdGhlIDVVIERlbGwgMjYwMCBp bnN0ZWFkIGZvciB0aGUgc2FtZSBiYWxscGFyayBjb3N0LiAgSWYgeW91IG9y ZGVyIGl0IHdpdGggcmFjayByYWlscywgaXQgY29tZXMgYWxsIHNldCB1cCBm b3IgcmFjayBpbnN0YWxsYXRpb24uLi5hIHNwZWNpYWwgc2lkZXdheXMgZmFj ZXBsYXRlIGFuZCBldmVyeXRoaW5nLg0KIA0KQnkgdGhlIHdheSwgUkFJRC01 IGlzIG5vdCB0aGUgYmVzdCBmYXVsdCB0b2xlcmFuY2UsIFJBSUQtMSBvciBS QUlELTEwIGlzLiAgQW5kIHlvdSBjYW4gY2VydGFpbmx5IGhvdC1zd2FwIFJB SUQtMTAgYXJyYXlzLiAgSSd2ZSBhY3R1YWxseSBkb25lIGl0Li4uLnJlY2Vu dGx5ISAgSSBhbSBvZiB0aGUgbWluZCB0aGF0IHNpbmdsZSBkcml2ZXMgYXJl IG5vdCBhbiBvcHRpb24gZm9yIHByb2R1Y3Rpb24gc2VydmVycyAtIEkganVz dCBkb24ndCBuZWVkIHRoZSBwYWluIG9mIHRoZSBzZXJ2ZXIgZ29pbmcgZG93 biBhdCBhbGwuICBBbHRob3VnaCB0aGV5IERPIGdvIGRvd24gZGVzcGl0ZSBy ZWR1bmRhbmN5Li4uSSBqdXN0IGhhZCBhIFNDU0kgYmFja3BsYW5lIGdvIG91 dCBpbiBhIERlbGwgNjYwMCB0aGF0IGhhcyBldmVyeSBiaXQgb2YgcmVkdW5k YW5jeSB5b3UgY2FuIG9yZGVyLiAgV2hpbGUgdW5jb21tb24sIHRoZSBiYWNr cGxhbmUgaXMgb25lIG9uZSBvZiB0aGUgbWFueSBzaW5nbGUgcG9pbnRzIG9m IGZhaWx1cmUhICANCiANClJvbWFuIEZhaWwNClBPUyBQb3J0YWwsIEluYy4N CiANCiANCg0KCS0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tIA0KCUZyb206 IEJhbGF6cyBXZWxsaXNjaCBbbWFpbHRvOmJhbGF6c0BuZXVzb2x1dGlvbnMu Y29tXSANCglTZW50OiBXZWQgNy8xNi8yMDAzIDc6NTcgUE0gDQoJVG86IHBn c3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3JnIA0KCUNjOiANCglTdWJq ZWN0OiBbUEVSRk9STV0gSGFyZHdhcmUgcGVyZm9ybWFuY2UNCgkNCgkNCglI aSBhbGwsDQoJIA0KCWZpcnN0IG9mIGFsbCBJJ2QgbGlrZSB0byB0aGFuayBl dmVyeW9uZSB3aG8gcmVzcG9uZGVkIHRvIG15IGVhcmxpZXIgcG9zdC4gSSBo YXZlIGEgbXVjaCBiZXR0ZXIgdW5kZXJzdGFuZGluZyBvZiBwb3N0Z3JlcyBw ZXJmb3JtYW5jZSB0dW5pbmcgbm93LiBJbiBjYXNlIGFueW9uZSdzIGludGVy ZXN0ZWQgd2UndmUgZGVjaWRlZCB0byBnbyB3aXRoIFJIOSBhbmQgUG9zdGdy ZVNRTCA3LjMgYW5kIHdlJ2xsIGRvIHRoZSBPUyBhbmQgREIgdHVuaW5nIG91 cnNlbHZlcy4gKHNob3VsZCBiZSBhIGdvb2QgbGVhcm5pbmcgZXhwZXJpZW5j ZSkNCgkgDQoJV2UgYXJlIG5vdyBnZXR0aW5nIHJlYWR5IHRvIHB1cmNoYXNl IHRoZSBoYXJkd2FyZSB0aGF0IHdpbGwgYmUgdXNlZCB0byBydW4gdGhlIGRh dGFiYXNlIHNlcnZlci4gV2UncmUgc3BlbmRpbmcgcXVpdGUgYSBiaXQgb2Yg bW9uZXkgb24gaXQgYmVjYXVzZSB0aGlzIHdpbGwgZXZlbnR1YWxseSwgaWYg dGhpbmdzIGdvIHdlbGwgd2l0aGluIHR3byBtb250aHMsIGJlY29tZSBhIHBy b2R1Y3Rpb24gc2VydmVyLiBXZSdyZSBnZXR0aW5nIGFsbCBSSCBjZXJ0aWZp ZWQgaGFyZHdhcmUgZnJvbSBEZWxsLiAoRGVsbCAyNjUwKQ0KCSANCglXZSdy ZSBub3cgc3R1Y2sgb24gdGhlIHF1ZXN0aW9uIG9mIHdoYXQgdHlwZSBvZiBS QUlEIGNvbmZpZ3VyYXRpb24gdG8gdXNlIGZvciB0aGlzIHNlcnZlci4gUkFJ RCA1IG9mZmVycyB0aGUgYmVzdCBmYXVsdCB0b2xlcmFuY2UgYnV0IGRvZXNu J3QgcGVyZm9ybSBhbGwgdGhhdCB3ZWxsLiBSQUlEIDEwIG9mZmVycyBtdWNo IGJldHRlciBwZXJmb3JtYW5jZSwgYnV0IG5vIGhvdCBzd2FwLiBPciBzaG91 bGQgd2Ugbm90IHVzZSBSQUlEIGF0IGFsbC4gSSBrbm93IHRoYXQgaWRlYWxs eSB0aGUgbG9nIChXQUwpIGZpbGVzIHNob3VsZCByZXNpZGUgb24gYSBzZXBh cmF0ZSBkaXNrIGZyb20gdGhlIHJlc3Qgb2YgdGhlIERCLiBTaG91bGQgd2Ug dXNlIDQgc2VwYXJhdGUgZHJpdmVzIGluc3RlYWQ/IE9uZSBmb3IgdGhlIE9T LCBvbmUgZm9yIGRhdGEsIG9uZSBmb3IgV0FMLCBvbmUgZm9yIHN3YXA/IE9y IFJBSUQgMTAgZm9yIGV2ZXJ5dGhpbmcgcGx1cyAxIGRyaXZlIGZvciBXQUw/ IE9yIFJBSUQgNSBmb3IgZXZlcnl0aGluZz8NCgkgDQoJV2UgaGF2ZSB0aGUg YnVkZ2V0IGZvciA1IGRyaXZlcy4gRG9lcyBhbnlvbmUgaGF2ZSBhbnkgcmVh bCB3b3JsZCBleHBlcmllbmNlIHdpdGggd2hhdCBoYXJkIGRyaXZlIGNvbmZp Z3VyYXRpb24gd29ya3MgYmVzdCBmb3IgcG9zdGdyZXM/IFRoaXMgaXMgZ29p bmcgdG8gYmUgYSBkZWRpY2F0ZWQgREIgc2VydmVyLiBUaGVyZSBhcmUgZ29p bmcgdG8gYmUgYSBsYXJnZSBudW1iZXIgb2YgdHJhbnNhY3Rpb25zIGJlaW5n IHdyaXR0ZW4gdG8gdGhlIGRhdGFiYXNlLiAoSW5mb3JtYXRpb24gaXMgbG9n Z2VkIGZyb20gYSBzZXBhcmF0ZSBhcHAgdGhyb3VnaCBPREJDIHRvIHBvc3Rn cmVzKSBBbmQgdGhlcmUgd2lsbCBiZSBzb21lIG1vZGVyYXRlbHkgY29tcGxl eCBxdWVyaWVzIHJ1biBjb25jdXJyZW50bHkgdG8gcHJlc2VudCB0aGlzIGlu Zm9ybWF0aW9uIGluIHRoZSBmb3JtIG9mIHZhcmlvdXMgcmVwb3J0cyBvbiB0 aGUgd2ViLiAoVGhlIGFwcCBzZXJ2ZXIgaXMgYSBzZXBhcmF0ZSBtYWNoaW5l IGFuZCB3aWxsIGNvbm5lY3QgdG8gdGhlIERCIHRocm91Z2ggSkRCQyB0byBj cmVhdGUgdGhlIEhUTUwgcmVwb3J0cykNCgkgDQoJQW55IHRob3VnaHRzLCBp ZGVhcywgY29tbWVudHMgd291bGQgYmUgYXBwcmVjaWF0ZWQuDQoJIA0KCVRo YW5rIHlvdSwNCgkgDQoJQmFsYXpzIFdlbGxpc2NoDQoJTmV1IFNvbHV0aW9u cw0KCWJhbGF6c0BuZXVzb2x1dGlvbnMuY29tDQoJIA0KDQo=