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 1gP9Fy-0001Pt-5q for pgsql-admin@arkaria.postgresql.org; Tue, 20 Nov 2018 16:52:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gP9Fv-0001kO-Lv for pgsql-admin@arkaria.postgresql.org; Tue, 20 Nov 2018 16:52:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP9Fu-0001kG-VN for pgsql-admin@lists.postgresql.org; Tue, 20 Nov 2018 16:52:07 +0000 Received: from mail-oln040092001108.outbound.protection.outlook.com ([40.92.1.108] helo=NAM01-BY2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP9Fr-0008MM-Br for pgsql-admin@postgresql.org; Tue, 20 Nov 2018 16:52:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=zgkcqORsUqhrjqVaXFpLshdz9FTQ9/O+et6trExt1F0=; b=YOykAnBVjdSq3vZcs5wHUlvNAN8SPdilYFF5YIZ2I9ceEXVsJ/BMn3EEf91ysF9HoRA5JmFxgBZFTkb6bRfFpGg1dQ479o6DbgRNXFIkpEME94UoNlUr9So+aMglU5FsBoNuI4PDjbmgHEdXGm11fVuGyrRxImu3GJFah0SnLJ/KSklY5GTrrRssMlwhSVC2bEfwX9v4fdgZBngt4BtJXfx5BH620lG3JlNxYwclv7Xy9xsld+17E5Z2xMn/SWmiKaDJJ/0Cyjb51DGLGR894MTP2wPYb+7LiSXi4oFbtMbLVde6Yehsp9MnTPOZ3ZVyMpFQzRxrTpl6om57RJBYlQ== Received: from BY2NAM01FT063.eop-nam01.prod.protection.outlook.com (10.152.68.58) by BY2NAM01HT148.eop-nam01.prod.protection.outlook.com (10.152.69.24) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1339.10; Tue, 20 Nov 2018 16:52:01 +0000 Received: from BYAPR01MB3848.prod.exchangelabs.com (10.152.68.54) by BY2NAM01FT063.mail.protection.outlook.com (10.152.69.76) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1339.10 via Frontend Transport; Tue, 20 Nov 2018 16:52:01 +0000 Received: from BYAPR01MB3848.prod.exchangelabs.com ([fe80::9536:1f56:49d:8fe5]) by BYAPR01MB3848.prod.exchangelabs.com ([fe80::9536:1f56:49d:8fe5%2]) with mapi id 15.20.1339.026; Tue, 20 Nov 2018 16:52:01 +0000 From: Ravi Krishna To: David Modica CC: "pgsql-admin@postgresql.org" Subject: Re: inserts take longer and longer Thread-Topic: inserts take longer and longer Thread-Index: AdSA6FaSSO61egjRT9+Avtk8bBh1aQACQRAA Date: Tue, 20 Nov 2018 16:52:01 +0000 Message-ID: References: <9a645d6c8749483c90f5f109889ea8ce@imaginesoftware.com> In-Reply-To: <9a645d6c8749483c90f5f109889ea8ce@imaginesoftware.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-clientproxiedby: DM5PR07CA0112.namprd07.prod.outlook.com (2603:10b6:4:ae::41) To BYAPR01MB3848.prod.exchangelabs.com (2603:10b6:a02:84::15) x-incomingtopheadermarker: OriginalChecksum:2F22385A5E6787B5B4AF9D0C948BF26CB0753A70F540C83CE24A397E376A2521;UpperCasedChecksum:9454C7ACCDFE35DDCDFF4E654EEA1E061684188A35C71515081CA52367FE8D6F;SizeAsReceived:7402;Count:50 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [UslAfp1fDnSOdf+bZnbjOqFJSxrJmn9p] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;BY2NAM01HT148;6:P7yVCJ7PFodC4rhciBtaX1cJobd0/rQ1tnXPwkGn3oJEZovmNAV8BfeuMH2CGQP4zMzrKbPPLlgJqRJEbx++UMmlJhWUelFHWoX8IerFaABPbYYNOn2WOF2r1R0Lve2nelbqB3EjjGaHNk15/7MGsmluO/qrgXRD04xkwDcPFwQ/WAoFO997UOmpNsFqH7kv+gxrkYu/ECB0Y+s3UApBomjMzPpEjkd6lOdWfodedQS2JG91INCcKorsB8GaJ1syXj0TwbsbFQUuco8KndQ6e31gyPo+OE74JGuy+/OBm+4xM2s0KCNxv/PWkwkEGzSPq+sdgFR5EpqLBza4+bhyOv+JOvYmPu6XQYqFWm0Uvgk5o8AhA0JtvtUZ2SIQdOBHeapyPidsVh9k6sWFylWZIyHEUhCEcJbWXTtaYip/ikH6a8J/YDZYlRo1V0XbuHjIKF6p3uIqUa7ChyNSkmkZIg==;5:G/9mkCn3haOg8rfjSwu884cJRBNLJkDZI5gB+gaOJXjP5ccHCLw2rZRNxPL3ILV/0Y4JC5b5i5h9eVFlC6UjMQtsnk875D4N+Xl9RiGYpNCFdey9kNaqZFs31ZirSmW/aGJkfWfY1bG0CfvME4q0WME9VtcFQTUtrcymdlC8a48=;7:baFM56Fn91xQ0XvK5ILb9Yt3kviw7GlEHrZsr4tiVx1EYdL3mhwbkjSGTsPiff4uGlDgW6u2vN3VxMFmylbF2EvdAbNl1UIRMDhEwVTveyEuVri+ud5zm3fp2o/5JnXiNGooKrebsFBT0KIxkSn2fw== x-incomingheadercount: 50 x-eopattributedmessage: 0 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390098)(7020095)(201702061078)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031324274)(2017031323274)(2017031322404)(1603101475)(1601125500)(1701031045);SRVR:BY2NAM01HT148; x-ms-traffictypediagnostic: BY2NAM01HT148: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(4566010)(82015058);SRVR:BY2NAM01HT148;BCL:0;PCL:0;RULEID:;SRVR:BY2NAM01HT148; x-microsoft-antispam-message-info: 1MkRh9Vdn9MNCcDDe1FuKs3s2zpHfmrEfIHwvyI76cycC9Gqfmr+RmaW5/knGjkg Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: f12efbb0-867f-4c93-8261-502eceebfafa X-MS-Exchange-CrossTenant-Network-Message-Id: 17c60062-4ff5-4ddd-0f9e-08d64f087e21 X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: f12efbb0-867f-4c93-8261-502eceebfafa X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Nov 2018 16:52:01.6119 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY2NAM01HT148 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PiANCj4gd2UgaGF2ZSBhIGRldmVsb3BlciB3aG8gaXMgZG9pbmcNCj4gYmF0Y2ggaW5zZXJ0cyAy MCBhdCBhIHRpbWUgYW5kIGVhY2ggc3Vic2VxdWVudCBiYXRjaCBpcyB0YWtpbmcNCj4gbG9uZ2Vy IHRvIHRoZSBwb2ludCB3aGVyZSBpdCBpcyBhIGNyaXRpY2FsIHByb2JsZW0uIEkgcmVjZW50bHkg Y2hhbmdlZA0KPiB0aGUgb3V0IG9mIHRoZSBib3ggY29uZmlnIHRvIHNlZSBpZiB0aGF0IHdvdWxk IGhlbHAgYnV0IGl0IGhhc27igJl0Og0KPiANCg0KSSByZWNvbGxlY3QgcmVhZGluZyBzb21ldGhp bmcgZmV3IHllYXJzIGFnbywgYnV0IG5vdCBhYmxlIHRvIHBsYWNlIG15IGZpbmdlciBvbiB0aGUg aXNzdWUuIElJUkMgaXQgd2FzIHNvbWV0aGluZyB0byBkbyB3aXRoIHRoZSBpbnNlcnRpbmcgc2Vz c2lvbiBjcmVhdGluZyBhIEhPVCBibG9hdCBiZWNhdXNlIHZhY2N1bSBjb3VsZCBub3QgZG8gYW55 dGhpbmcgb24gdGhhdCBsaXZlIHNlc3Npb24uICBJIHdpbGwgdHJ5IHRvIHNlYXJjaCBmb3IgdGhh dCBwb3N0LiAgQnV0IHRoZSBzeW1wdG9tcyB3ZXJlIHNpbWlsYXIgdG8geW91cnMuICBJbml0aWFs bHkgZ29vZCBwZXJmb3JtYW5jZSBhbmQgdGhlbiBnZXR0aW5nIHNsb3dlciBhbmQgc2xvd2VyLg0K DQpROiBJcyBpdCBzdHJhaWdodCBpbnNlcnQgb3IgeW91IGRvIHNlbGVjdCBvciB1cGRhdGVzIGFs c28gYWxvbmcgd2l0aCBpbnNlcnQu