Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1id9fd-0007lV-46 for pgsql-docs@arkaria.postgresql.org; Fri, 06 Dec 2019 09:13:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1id9fb-0002je-TZ for pgsql-docs@arkaria.postgresql.org; Fri, 06 Dec 2019 09:13:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ictEf-0006ZE-5h for pgsql-docs@lists.postgresql.org; Thu, 05 Dec 2019 15:40:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ictEb-00086k-U6 for pgsql-docs@lists.postgresql.org; Thu, 05 Dec 2019 15:40:08 +0000 Content-Type: multipart/mixed; boundary="===============1186981384120993415==" MIME-Version: 1.0 Subject: Difference between Bulk Load (Multiple inserts or single inserts) and COPY To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: mayank.l.patel90@gmail.com Reply-To: mayank.l.patel90@gmail.com, pgsql-docs@lists.postgresql.org Date: Thu, 05 Dec 2019 15:39:24 +0000 Message-ID: <157556036483.25843.13507499162781497696@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1186981384120993415== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMC9zcWwt Y29weS5odG1sCkRlc2NyaXB0aW9uOgoKSGVsbG8sDQoNCj4gSSBleHBlcmltZW50ZWQgd2l0aCBC dWxrIGxvYWQgYW5kIENPUFkuDQo+IExvYWRpbmcgaW4gQ09QWSB3YXMgdmVyeSBmYXN0Lg0KPiBI b3dldmVyLCBhZnRlciBDT1BZaW5nIGRhdGEgZnJvbSBhIENTViBmaWxlIHRvIFBvc3RncmVTUUwg VGFibGUuIFRoZQpxdWVyeQ0KPiBleGVjdXRpb24gdG9vayBsb3Qgb2YgdGltZSBmb3IgMSBvZiB0 aGUgZmlyc3QgNCBxdWVyaWVzLg0KPiBPbmx5IHRoaXMgc2xvdyBxdWVyeSB3YXMgdGFraW5nIHNv IG11Y2ggdGltZSwgdGhhdCBldmVuIGlmIEkgaGFkIHVzZWQKbm9ybWFsDQo+IGJ1bGsgbG9hZCwg aXQgd291bGQgaGF2ZSBiZWVuIGZhc3RlciBpbiB0b3RhbC4NCj4gVGhlbiBhbGwgb3RoZXIgUXVl cnkgZXhlY3V0aW9ucyB0b29rIGVxdWFsIHRpbWUgYXMgaXQgdG9vayB3aGlsZSBxdWVyeWluZwph DQo+IHRhYmxlIGFmdGVyIHRoZSBCdWxrIGRhdGEgbG9hZCBtZXRob2QuDQo+DQo+IFNvLCBJIHdh bnQgdG8ga25vdyB0aGUgZXhhY3QgcmVhc29uIHdoYXQncyB0aGUgaXNzdWUgd2l0aCBDT1BZLg0K PiBIb3cgZXhhY3RseSB0aGV5IGRpZmZlcj8gVGhlIG9ubHkgdGhpbmcgZnJvbSB0aGUgZG9jdW1l bnQgSSBjb3VsZAppZGVudGlmeQ0KPiB3YXMgcm93IHNlY3VyaXR5Lg0KPiBCdXQgaXQgZGlkIG5v dCBtZW50aW9uIGFueXRoaW5nIGFib3V0IGluZGV4aW5nLiBMaWtlLCBpbiBCdWxrIGxvYWQsIGRv DQo+IGluZGljZXMob3IgY29uc3RyYWludCBjaGVja3MpIGFyZSBjcmVhdGVkIHdpdGggZGF0YSBs b2FkaW5nPw0KPiAmIGluIENPUFkgaXQncyBkb25lIGFmdGVyPyBzbyB3aGVuIGluZGljZXMgYXJl IGJlaW5nIGNyZWF0ZWQgdGhhdCBxdWVyeQ0KPiBzbG93cyBkb3duPz8NCg0KKkFkZGVkIGRldGFp bHMqDQoNCiJUYWJsZSAmIFF1ZXJ5IGRldGFpbHMiDQpJIGhhdmUgMSBUYWJsZSBpcyB0aGVyZSBo YXZpbmcgMyBhdHRyaWJ1dGVzOg0KVGFibGVOYW1leyBDb2x1bW4xIFZhcmNoYXIzMDAsICBDb2x1 bW4yIFZhcmNoYXIzMDAsICBDb2x1bW4zIFZhcmNoYXIzMDB9Ow0KSSBoYXZlbid0IGNyZWF0ZWQg YW55IHByaW1hcnkga2V5cyBvciBGS3MuIE5vIG90aGVyIGNvbnN0cmFpbnRzLg0KDQpEYXRhIHNl dCBzaXplOiAxNTBNQiAvIDFNIHJlY29yZHMNCg0KUXVlcmllczoNClNlbGVjdCBjb3VudCgqKSBm cm9tIFRhYmxlOw0KU2VsZWN0IGNvdW50KGRpc3RpbmN0KCBDb2x1bW4xLCBDb2x1bW4yICwgQ29s dW1uMyApKSBmcm9tIFRhYmxlOw0KU2VsZWN0IENvbHVtbjEsIENvbHVtbjIsIENvbHVtbjMgZnJv bSBUYWJsZSBhcyBUMSwgVGFibGUgYXMgVDIsICBUYWJsZSBhcyBUMwp3aGVyZSBUMS4gQ29sdW1u MT1UMi5Db2x1bW4zIGFuZCBUMS4gQ29sdW1uMT0ieHl6IjsNCg0KUGxlYXNlIGxldCBtZSBrbm93 LCBob3cgQnVsayBsb2FkIHZzLiBDT1BZIGRpZmZlcmVudCBpbiBib3RoIHNpdHVhdGlvbnMNCjEp IERvIHRoZSBpbnRlcm5hbCByZXByZXNlbnRhdGlvbiBkaWZmZXJzIGFmdGVyIGRhdGEgaXMgbG9h ZGVkIHVzaW5nIEJ1bGsKdnMuIENPUFk/DQoyKSB3aGF0IGlmIEkgaGF2ZSBhZGRlZCBLZXlzIGFu ZCBDb25zdHJhaW50cywgYXJlIHRoZXkgY2hlY2tlZCBsYXRlcj8gTWVhbnMKbG9hZGluZyBpcyBz aG93biBjb21wbGV0ZWQgYnV0IGluIGJhY2tncm91bmQgaXQncyBjcmVhdGluZyBpbmRpY2VzL2No ZWNraW5nCmNvbnN0cmFpbnRzLg0KMykgQ2FuIGl0IGJlIHRoZSByZWFzb24gdGhhdCBzb21lIG90 aGVyIHByb2Nlc3Mod2hpY2g/KSBpcyBydW5uaW5nIGluCmJhY2tncm91bmQgZHVyaW5nIHF1ZXJ5 IGV4ZWN1dGlvbiA/IGFzIEkgcXVlcnkgdGhlIGRhdGEgYXMgc29vbiBhcyB0aGUgbG9hZAphZnRl ciBDT1BZIGlzIGNvbXBsZXRlLgo= --===============1186981384120993415==--