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 1gP8qb-0008N8-IA for pgsql-admin@arkaria.postgresql.org; Tue, 20 Nov 2018 16:25:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gP8qa-0006PL-42 for pgsql-admin@arkaria.postgresql.org; Tue, 20 Nov 2018 16:25:56 +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 1gP8NK-0003le-Ej for pgsql-admin@lists.postgresql.org; Tue, 20 Nov 2018 15:55:42 +0000 Received: from smtp98.ord1c.emailsrvr.com ([108.166.43.98]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP8NH-0005zg-Eu for pgsql-admin@postgresql.org; Tue, 20 Nov 2018 15:55:41 +0000 Received: from smtp13.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp13.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id F0ADCA0460 for ; Tue, 20 Nov 2018 10:55:36 -0500 (EST) X-SMTPDoctor-Processed: csmtpprox beta Received: from smtp13.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp13.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id EF21DA0540 for ; Tue, 20 Nov 2018 10:55:36 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=imaginesoftware.com; s=20170104; t=1542729336; bh=PpkYtPXmJcl1lHyeD/zQOzlPaOQe59uGY4P1vcufcFQ=; h=From:To:Subject:Date:From; b=iSfBy+Bf6t1I2gUfBXYh1+aRQxwW0Zth8Dfp0xUbih6kaCF25W1uN+rZPIaYxvQAd gPLVOChWIedGudQ4GOCRx2QBhVkaoHhRadzC0Elygk9sun97opz2uRbEjmoVXkq2g9 LKUnI6bCJicgzxyG4sx8CaI08pIg1+vpHTSUVHC0= Received: from smtp192.mex09.emailsrvr.com (unknown [184.106.73.70]) by smtp13.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTPS id 9CEB6A0460 for ; Tue, 20 Nov 2018 10:55:35 -0500 (EST) X-Sender-Id: davidmo@imaginesoftware.com Received: from smtp192.mex09.emailsrvr.com ([UNAVAILABLE]. [184.106.73.70]) (using TLSv1.2 with cipher AES256-GCM-SHA384) by 0.0.0.0:25 (trex/5.7.12); Tue, 20 Nov 2018 10:55:36 -0500 Received: from MBX01D-ORD1.mex09.mlsrvr.com (172.29.128.27) by MBX01D-ORD1.mex09.mlsrvr.com (172.29.128.27) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1466.3; Tue, 20 Nov 2018 09:55:35 -0600 Received: from MBX01D-ORD1.mex09.mlsrvr.com ([fe80::c9b1:8c28:1031:4efd]) by MBX01D-ORD1.mex09.mlsrvr.com ([fe80::c9b1:8c28:1031:4efd%21]) with mapi id 15.01.1466.003; Tue, 20 Nov 2018 09:55:35 -0600 From: David Modica To: "pgsql-admin@postgresql.org" Subject: inserts take longer and longer Thread-Topic: inserts take longer and longer Thread-Index: AdSA6FaSSO61egjRT9+Avtk8bBh1aQ== Date: Tue, 20 Nov 2018 15:55:34 +0000 Message-ID: <9a645d6c8749483c90f5f109889ea8ce@imaginesoftware.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [4.31.46.200] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk aGkgYWxsLiANCg0KSSBob3BlIHRoaXMgaXMgdGhlIGNvcnJlY3Qgd2F5IHRvIGdldCBoZWxwIGZy b20gdGhlIGxpc3QuDQoNCndlIGFyZSBwb3N0Z3JlcyAxMC40IDoNCiMgREIgVmVyc2lvbjogMTAN CiMgT1MgVHlwZTogbGludXgNCiMgREIgVHlwZTogbWl4ZWQNCiMgVG90YWwgTWVtb3J5IChSQU0p OiA2MCBHQg0KIyBDUFVzIG51bTogMjINCiMgQ29ubmVjdGlvbnMgbnVtOiAxMDANCiMgRGF0YSBT dG9yYWdlOiBzYW4NCg0KIHdlIGhhdmUgYSBkZXZlbG9wZXIgd2hvIGlzIGRvaW5nDQpiYXRjaCBp bnNlcnRzIDIwIGF0IGEgdGltZSBhbmQgZWFjaCBzdWJzZXF1ZW50IGJhdGNoIGlzIHRha2luZw0K bG9uZ2VyIHRvIHRoZSBwb2ludCB3aGVyZSBpdCBpcyBhIGNyaXRpY2FsIHByb2JsZW0uIEkgcmVj ZW50bHkgY2hhbmdlZA0KdGhlIG91dCBvZiB0aGUgYm94IGNvbmZpZyB0byBzZWUgaWYgdGhhdCB3 b3VsZCBoZWxwIGJ1dCBpdCBoYXNu4oCZdDoNCg0KbWF4X2Nvbm5lY3Rpb25zID0gMTAwDQpzaGFy ZWRfYnVmZmVycyA9IDE1R0INCmVmZmVjdGl2ZV9jYWNoZV9zaXplID0gNDVHQg0KbWFpbnRlbmFu Y2Vfd29ya19tZW0gPSAyR0INCmNoZWNrcG9pbnRfY29tcGxldGlvbl90YXJnZXQgPSAwLjkNCndh bF9idWZmZXJzID0gMTZNQg0KZGVmYXVsdF9zdGF0aXN0aWNzX3RhcmdldCA9IDEwMA0KcmFuZG9t X3BhZ2VfY29zdCA9IDEuMQ0KZWZmZWN0aXZlX2lvX2NvbmN1cnJlbmN5ID0gMzAwDQp3b3JrX21l bSA9IDcxNDlrQg0KbWluX3dhbF9zaXplID0gMUdCDQptYXhfd2FsX3NpemUgPSAyR0INCm1heF93 b3JrZXJfcHJvY2Vzc2VzID0gMjINCm1heF9wYXJhbGxlbF93b3JrZXJzX3Blcl9nYXRoZXIgPSAx MQ0KbWF4X3BhcmFsbGVsX3dvcmtlcnMgPSAyMg0KDQoNCmFueSBkaXJlY3Rpb24gYXMgdG8gd2hh dCB0byBsb29rIGF0IHdvdWxkIGJlIGFwcHJlY2lhdGVkLg0KDQpkYXZpZA0K