Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 6A7BC2E004F for ; Tue, 8 Apr 2008 06:18:31 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 97898-04 for ; Tue, 8 Apr 2008 06:18:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fabaglexfr.fabasoft.com (fabaglexfr.fabasoft.com [192.84.221.196]) by developer.postgresql.org (Postfix) with ESMTP id 7D3682E004A for ; Tue, 8 Apr 2008 06:18:19 -0300 (ADT) Received: from FABAMAIL.fabagl.fabasoft.com ([10.10.5.137]) by fabaglexfr.fabasoft.com with InterScan Messaging Security Suite; Tue, 08 Apr 2008 11:17:32 +0200 x-mimeole: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 Subject: Re: Looking for bottleneck during load test Date: Tue, 8 Apr 2008 11:16:14 +0200 Message-ID: In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] Looking for bottleneck during load test Thread-Index: AciZVzwzZ2zHM+dyTq6ApqxAU6LKJAAAGi1Q References: From: "Hell, Robert" To: "Ivan Voras" , X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/86 X-Sequence-Number: 29579 V29yc3QgbGF0ZW5jeSB3YXMgYXQgfjYwMCBtcy4NCg0KSW4gdGhpcyB0ZXN0IGNhc2Ugd2UgaGF2 ZSBvbmx5IHNlbGVjdHMgLSBzbyBpdCdzIHJlYWQgb25seS4NCg0KSSB0cmllZCA4LjMgLSBpdCdz IGJldHRlciB0aGVyZSAoMTAtMTUgJSkgLSBidXQgSU8gcmF0ZXMgc3RheSB0aGUgc2FtZS4NCkkg dXNlIDE4IEdCIHNoYXJlZCBtZW1vcnkgb24gYSBtYWNoaW5lIHdpdGggMzIgR0IgZHVyaW5nIHRo ZSB0ZXN0LCBJIHRoaW5rIHRoaXMgc2hvdWxkbid0IGJlIGEgcHJvYmxlbS4NCg0KSSBkaWQgc29t ZSBmdXJ0aGVyIHRlc3RpbmcgYW5kIEkgbm93IHJlYWxseSB0aGluayB0aGF0IGRpc2sgaXMgdGhl IGJvdHRsZW5lY2sgaGVyZS4gDQpJJ20gcmVhbGx5IHN1cnByaXNlZCB0aGF0IHRob3NlIDcgTUIv cyBpbiBhdmVyYWdlIGFyZSB0aGUgbWF4aW11bSBmb3IgdGhhdCBkaXNrcy4NCg0KQW55IGZpbGVz eXN0ZW0gKGV4dDMpIHNldHRpbmdzIHRoYXQgY291bGQgaGVscCBoZXJlPw0KDQpSZWdhcmRzLA0K Um9iZXJ0DQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IHBnc3FsLXBlcmZv cm1hbmNlLW93bmVyQHBvc3RncmVzcWwub3JnIFttYWlsdG86cGdzcWwtcGVyZm9ybWFuY2Utb3du ZXJAcG9zdGdyZXNxbC5vcmddIE9uIEJlaGFsZiBPZiBJdmFuIFZvcmFzDQpTZW50OiBEaWVuc3Rh ZywgMDguIEFwcmlsIDIwMDggMTE6MDMNClRvOiBwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3Fs Lm9yZw0KU3ViamVjdDogUmU6IFtQRVJGT1JNXSBMb29raW5nIGZvciBib3R0bGVuZWNrIGR1cmlu ZyBsb2FkIHRlc3QNCg0KSGVsbCwgUm9iZXJ0IHdyb3RlOg0KPiA+IEkgdHJpZWQgZGlmZmVyZW50 IG90aGVyIHRvb2xzIGZvciByYW5kb20gSU8gKGluY2x1ZGluZyBhIHNlbGYNCndyaXR0ZW4gb25l IHdoaWNoIGRvZXMgcmFuZG9tIGxzZWVrIGFuZCByZWFkKS4NCj4gPg0KPiA+IFRoaXMgdG9vbCwg c3RhcnRlZCBkdXJpbmcgb25lIG9mIG91ciB0ZXN0cywgYWNoaWV2ZXMgMiBpb3BzICg4ayBlYWNo KS4NCj4gPiBTdGFydGVkIGFsb25lIEkgZ2V0IHNvbWV0aGluZyBhYm91dCAxLDUwMCBpb3BzIHdp dGggYW4gYXZnIGxhdGVuY3kNCm9mIDEwMCBtcy4NCg0KMTUwMCBpb3BzIGxvb2tzIGFib3V0IHJp Z2h0IGZvciA0eDIgUkFJRCAxMCB2b2x1bWUuIFdoYXQncyB5b3VyIHdvcnN0DQpsYXRlbmN5IChh cyByZXBvcnRlZCBieSB0aGUgdG9vbCk/IGlvd2FpdCBpcyBtb3N0bHkgc2VlayB0aW1lLg0KDQo+ ID4gV2UgYXJlIHVzaW5nIFNBTiAoRU1DIENMQVJpaU9OIENYIDMwMCkgLSBhcmUgdGhvc2Ugfjcg TUIvcyByZWFsbHkNCm91ciBib3R0bGVuZWNrPw0KDQpEZXBlbmRpbmcgb24geW91ciBhY2Nlc3Mg cGF0dGVybiB0byB0aGUgZGF0YWJhc2UsIGl0IGNvdWxkIGJlIChpZiB5b3UNCmhhdmUgbG90cyBv ZiByYW5kb20gSU8sIGFuZCAxODAgY29uY3VycmVudCBkYXRhYmFzZSB0aHJlYWRzIGNhbiBtYWtl IGFueQ0KSU8gcmFuZG9tIGVub3VnaCkuIEFyZSB5b3VyIHF1ZXJpZXMgcmVhZC1tb3N0bHkgb3Ig YSBtaXg/DQoNCj4gPiBBbnkgb3RoZXIgdHVuaW5nIGlkZWFzPw0KDQpPbmx5IGdlbmVyaWMgb25l czoNCg0KLSBBcmUgeW91ciBxdWVyaWVzIG9wdGltaXplZCwgdXNlIGluZGV4ZXMsIGV0Yy4/DQot IFRyeSBQb3N0Z3JlU1FMIDguMyAtIGlmIHlvdSBoYXZlIHNlcXVlbnRpYWwgc2Vla3MgaXQgY2Fu IGluIHRoZW9yeQ0KbWFrZSBiZXR0ZXIgdXNlIG9mIGRhdGEgYmV0d2VlbiBjb25uZWN0aW9ucy4N Ci0gRG8geW91IGhhdmUgZW5vdWdoIG1lbW9yeSBkZWRpY2F0ZWQgdG8gZGF0YSBjYWNoZXMsIGJv dGggaW4gUG9zdGdyZVNRTA0KYW5kIGluIHRoZSBPUz8gKGkuZS4gd2hhdCBpcyB5b3VyIHNoYXJl ZF9idWZmZXJzIHNldHRpbmc/KQ0KLSBJZiB0aGUgU0FOIGNhbiBjb25maWd1cmUgcGFyYW1ldGVy cyBzdWNoIGFzIHByZWZldGNoIChwcmUtcmVhZCkgYW5kDQpzdHJpcGUgc2l6ZSwgdHJ5IGxvd2Vy aW5nIHRoZW0gKHNob3VsZCBoZWxwIGlmIHlvdSBoYXZlIHJhbmRvbSBJTykuDQoNCg0KLS0gDQpT ZW50IHZpYSBwZ3NxbC1wZXJmb3JtYW5jZSBtYWlsaW5nIGxpc3QgKHBnc3FsLXBlcmZvcm1hbmNl QHBvc3RncmVzcWwub3JnKQ0KVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOg0K aHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1wZXJmb3JtYW5jZQ0K