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 1iX9rq-0008QZ-G7 for pgsql-docs@arkaria.postgresql.org; Tue, 19 Nov 2019 20:12:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iX9rn-0003G2-Gk for pgsql-docs@arkaria.postgresql.org; Tue, 19 Nov 2019 20:12:51 +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 1iX8ff-0005Nb-Qp for pgsql-docs@lists.postgresql.org; Tue, 19 Nov 2019 18:56:15 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iX8fW-0005sA-6p for pgsql-docs@lists.postgresql.org; Tue, 19 Nov 2019 18:56:15 +0000 Content-Type: multipart/mixed; boundary="===============0678550202533787754==" 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: Tue, 19 Nov 2019 18:55:23 +0000 Message-ID: <157418972366.28426.16885409770050714771@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0678550202533787754== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMC9zcWwt Y29weS5odG1sCkRlc2NyaXB0aW9uOgoKSGVsbG8sIA0KDQpNeXNlbGYgTWF5YW5rLiBJIGFtIGEg UGguRC4gc3R1ZGVudC4NCg0KSSBleHBlcmltZW50ZWQgd2l0aCBCdWxrIGxvYWQgYW5kIENPUFku DQpMb2FkaW5nIGluIENPUFkgd2FzIHZlcnkgZmFzdC4gDQpIb3dldmVyLCBhZnRlciBDT1BZaW5n IGRhdGEgZnJvbSBhIENTViBmaWxlIHRvIFBvc3RncmVTUUwgVGFibGUuIFRoZSBxdWVyeQpleGVj dXRpb24gdG9vayBsb3Qgb2YgdGltZSBmb3IgMSBvZiB0aGUgZmlyc3QgNCBxdWVyaWVzLg0KT25s eSB0aGlzIHNsb3cgcXVlcnkgd2FzIHRha2luZyBzbyBtdWNoIHRpbWUsIHRoYXQgZXZlbiBpZiBJ IGhhZCB1c2VkIG5vcm1hbApidWxrIGxvYWQsIGl0IHdvdWxkIGhhdmUgYmVlbiBmYXN0ZXIgaW4g dG90YWwuDQpUaGVuIGFsbCBvdGhlciBRdWVyeSBleGVjdXRpb25zIHRvb2sgZXF1YWwgdGltZSBh cyBpdCB0b29rIHdoaWxlIHF1ZXJ5aW5nIGEKdGFibGUgYWZ0ZXIgdGhlIEJ1bGsgZGF0YSBsb2Fk IG1ldGhvZC4NCg0KU28sIEkgd2FudCB0byBrbm93IHRoZSBleGFjdCByZWFzb24gd2hhdCdzIHRo ZSBpc3N1ZSB3aXRoIENPUFkuDQpIb3cgZXhhY3RseSB0aGV5IGRpZmZlcj8gVGhlIG9ubHkgdGhp bmcgZnJvbSB0aGUgZG9jdW1lbnQgSSBjb3VsZCBpZGVudGlmeQp3YXMgcm93IHNlY3VyaXR5Lg0K QnV0IGl0IGRpZCBub3QgbWVudGlvbiBhbnl0aGluZyBhYm91dCBpbmRleGluZy4gTGlrZSwgaW4g QnVsayBsb2FkLCBkbwppbmRpY2VzKG9yIGNvbnN0cmFpbnQgY2hlY2tzKSBhcmUgY3JlYXRlZCB3 aXRoIGRhdGEgbG9hZGluZz8NCiYgaW4gQ09QWSBpdCdzIGRvbmUgYWZ0ZXI/IHNvIHdoZW4gaW5k aWNlcyBhcmUgYmVpbmcgY3JlYXRlZCB0aGF0IHF1ZXJ5CnNsb3dzIGRvd24/Pw0KDQpQbGVhc2Ug cmVwbHkgc29vbiB3aXRoIG1vcmUgZGV0YWlscyBvciBzZW5kIGEgbGluayB3aGVyZSBJIGNhbiBy ZWFkIGl0IGluCmRlcHRoLg0KVGhhbmtzLg0KTWF5YW5rLg0KbWF5YW5rLmwucGF0ZWw5MEBnbWFp bC5jb20K --===============0678550202533787754==--