Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YpJ5s-0006lo-FG for pgsql-admin@arkaria.postgresql.org; Mon, 04 May 2015 16:19:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YpJ5r-0002tC-RR for pgsql-admin@arkaria.postgresql.org; Mon, 04 May 2015 16:19:43 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YpJ5q-0002sq-MI for pgsql-admin@postgresql.org; Mon, 04 May 2015 16:19:42 +0000 Received: from mail-bl2on0127.outbound.protection.outlook.com ([65.55.169.127] helo=na01-bl2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1YpJ5n-0001MZ-0l for pgsql-admin@postgresql.org; Mon, 04 May 2015 16:19:40 +0000 Received: from BN1PR05MB009.namprd05.prod.outlook.com (10.255.202.141) by BN1PR05MB010.namprd05.prod.outlook.com (10.255.202.143) with Microsoft SMTP Server (TLS) id 15.1.154.19; Mon, 4 May 2015 16:19:36 +0000 Received: from BN1PR05MB009.namprd05.prod.outlook.com ([169.254.15.91]) by BN1PR05MB009.namprd05.prod.outlook.com ([169.254.15.91]) with mapi id 15.01.0154.018; Mon, 4 May 2015 16:19:36 +0000 From: Mel Llaguno To: Jan Lentfer , "pgsql-admin@postgresql.org" Subject: Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Thread-Topic: [ADMIN] pg_dump and pg_restore with multiple streams does Not seem to improve overall times Thread-Index: AQHQhCIVMZwF5n+m7kqWUfrWOGOCmp1rwD0A///fGoA= Date: Mon, 4 May 2015 16:19:36 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.3.9.131030 authentication-results: web.de; dkim=none (message not signed) header.d=none; x-ms-exchange-messagesentrepresentingtype: 1 x-originating-ip: [66.18.194.18] x-microsoft-antispam: UriScan:; BCL:0; PCL:0; RULEID:(42140001); SRVR:BN1PR05MB010; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0; PCL:0; RULEID:(601004)(5005006)(3002001); SRVR:BN1PR05MB010; BCL:0; PCL:0; RULEID:; SRVR:BN1PR05MB010; x-forefront-prvs: 05669A7924 x-forefront-antispam-report: SFV:NSPM; SFS:(10019020)(6009001)(51704005)(24454002)(479174004)(377454003)(377424004)(62966003)(77156002)(19300405004)(99286002)(54356999)(5001960100002)(5001770100001)(2900100001)(40100003)(107886002)(2950100001)(122556002)(36756003)(46102003)(106116001)(2501003)(15395725005)(86362001)(15975445007)(102836002)(92566002)(83506001)(1720100001)(50986999)(2656002)(4001350100001)(15974865002)(66066001)(76176999)(19580395003)(19580405001)(87936001)(562404015); DIR:OUT; SFP:1102; SCL:1; SRVR:BN1PR05MB010; H:BN1PR05MB009.namprd05.prod.outlook.com; FPR:; SPF:None; MLV:sfv; LANG:en; Content-Type: text/plain; charset="utf-8" Content-ID: <97DCA054A668DB47A4AC3D7C978E45E0@namprd05.prod.outlook.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: coverity.com X-MS-Exchange-CrossTenant-originalarrivaltime: 04 May 2015 16:19:36.5490 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 809a746c-a8df-4f37-86a4-bd3974a40f1e X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN1PR05MB010 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org TXkgdW5kZXJzdGFuZGluZyBvZiBwYXJhbGxlbCBkdW1wIHBlcmZvcm1hbmNl IGlzIHRoYXQgaXQgb25seSBtYWtlcyBhDQpkaWZmZXJlbmNlIHdoZW4geW91 IGhhdmUgYSBsYXJnZSBudW1iZXIgb2YgREJzICh0aG91c2FuZHMgaWYgbm90 IHRlbnMgb2YNCnRob3VzYW5kcykuIFdlIHBlcmZvcm1lZCBzaW1pbGFyIHRl c3RpbmcgdXNpbmcgOS4zLnggYW5kIGZvdW5kIGxpdHRsZQ0KcGVyZm9ybWFu Y2UgZ2FpbnMgdXNpbmcgLWogKHdpdGggMTAwKyB0YWJsZXMpLiBTZWUgQnJ1 Y2UgTW9tamlhbuKAmXMgcG9zdCA6DQpodHRwOi8vbW9tamlhbi51cy9tYWlu L2Jsb2dzL3BnYmxvZy8yMDEyLmh0bWwNCg0KTWVsIExsYWd1bm8g4oCiIFN0 YWZmIEVuZ2luZWVyIOKAkyBUZWFtIExlYWQNCk9mZmljZTogKzEuNDAzLjI2 NC45NzE3IHgzMzEwDQp3d3cuY292ZXJpdHkuY29tIDxodHRwOi8vd3d3LmNv dmVyaXR5LmNvbS8+IOKAoiBUd2l0dGVyOiBAY292ZXJpdHkNCg0KDQpPbiA1 LzQvMTUsIDY6MTcgQU0sICJKYW4gTGVudGZlciIgPEphbi5MZW50ZmVyQHdl Yi5kZT4gd3JvdGU6DQoNCj5BbSAyMDE1LTA1LTAxIDE3OjE2LCBzY2hyaWVi IFN1c2FuIEsuIE1jQ2x1cmU6DQo+DQo+Wy4uLl0NCj4+IE15IHBvc3RncmVz cWwuY29uZiBoYXMgdGhlc2Ugb3B0aW9ucyBmb3IgKGhvcGVmdWxseSkgcGdf ZHVtcCBhbmQNCj4+IHBnX3Jlc3RvcmUgaW1wcm92ZW1lbnRzOg0KPj4NCj4+ ID09PT09PT09PT09PT09PT09DQo+PiB3b3JrX21lbSA9IDFHQiAjIGR1bXAv cmVzdG9yZSBQZXJmIFZhbHVlDQo+PiAjbWFpbnRlbmFuY2Vfd29ya19tZW0g PSAyMDQ4TUIgIyBtaW4gMU1CDQo+PiBtYWludGVuYW5jZV93b3JrX21lbSA9 IDFHQiAjIGR1bXAvcmVzdG9yZSBQZXJmIFZhbHVlDQo+PiAjYXV0b3ZhY3V1 bV93b3JrX21lbSA9IC0xICMgbWluIDFNQiwgb3IgLTEgdG8gdXNlDQo+PiBt YWludGVuYW5jZV93b3JrX21lbQ0KPj4NCj4+IC4uLg0KPj4gZnN5bmMgPSBv ZmYgIyBkdW1wL3Jlc3RvcmUgUGVyZiBWYWx1ZWNoZWNrcG9pbnRfc2VnbWVu dHMgPSA2MCAjDQo+PiBkdW1wL3Jlc3RvcmUgUGVyZiBWYWx1ZQ0KPj4gY2hl Y2twb2ludF93YXJuaW5nID0gNjBzICMgZHVtcC9yZXN0b3JlIFBlcmYgVmFs dWUNCj4+IC4uLi4uLg0KPj4gYXV0b3ZhY3V1bSA9IG9mZiAjIGR1bXAvcmVz dG9yZSBQZXJmIFZhbHVlLi4NCj4+ID09PT09PT09PT09PT09PT09PT09PT09 PT09PT09DQo+Pg0KPj4gQW55IHRob3VnaHRzIG9uIHdoYXQgZWxzZSBJIG1p Z2h0IHRyeSB0byBpbXByb3ZlIHRoaW5ncyA/DQo+Wy4uLl0NCj4NCj5JdCBp c3QgbW9yZSBpbnRlcmVzdGluZyB0byBrbm93IGhvdyB5b3VyIGRhdGFiYXNl IHNjaGVtYSBpcy4gSG93IG1hbnkNCj4ibGFyZ2UiIHRhYmxlcyBkbyB5b3Ug aGF2ZS4gV2hhdCBpcyBlLmcuIHRoZSBzaXplIG9mIHlvdXIgMTAsMjAsMzAN Cj5sYXJnZXN0IHRhYmxlcz8NCj4NCj5SZWdhcmRzDQo+DQo+SmFuDQo+DQo+ DQo+DQo+DQo+LS0gDQo+U2VudCB2aWEgcGdzcWwtYWRtaW4gbWFpbGluZyBs aXN0IChwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZykNCj5UbyBtYWtlIGNo YW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246DQo+aHR0cDovL3d3dy5wb3N0 Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1hZG1pbg0KDQoKLS0gClNlbnQg dmlhIHBnc3FsLWFkbWluIG1haWxpbmcgbGlzdCAocGdzcWwtYWRtaW5AcG9z dGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlw dGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3Nx bC1hZG1pbgo=