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 1gPTMK-0006r3-Eq for pgsql-admin@arkaria.postgresql.org; Wed, 21 Nov 2018 14:20:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gPTMJ-0006wZ-AY for pgsql-admin@arkaria.postgresql.org; Wed, 21 Nov 2018 14:20:03 +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 1gPT7X-00060M-Ct for pgsql-admin@lists.postgresql.org; Wed, 21 Nov 2018 14:04:47 +0000 Received: from smtp122.ord1c.emailsrvr.com ([108.166.43.122]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPT7R-0003R8-83 for pgsql-admin@postgresql.org; Wed, 21 Nov 2018 14:04:46 +0000 Received: from smtp16.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp16.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id 9DD34C029D; Wed, 21 Nov 2018 09:04:40 -0500 (EST) X-SMTPDoctor-Processed: csmtpprox beta Received: from smtp16.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp16.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id 9B729C034F; Wed, 21 Nov 2018 09:04:40 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=imaginesoftware.com; s=20170104; t=1542809080; bh=RK2If4DLbmPZ1JGlRPx+QqlqN2JHSjyMoL8eS9amvfc=; h=From:To:Subject:Date:From; b=CGSLVHDhtiAiBFfn8y8cqC17lA+OGW81MsPvBkWTXbECYiZW9ojdnnD/GmSBE6Ex+ 9EkAxETaILjTzV/sYsVEvNLAzGQZbYKqqISlx/gp1i0inRsuy71xs9nIT4XLGxOXF4 ZeqGTHKcKlGqow2jnTPne6wfTCw9992J0mGZ55lU= Received: from smtp192.mex09.emailsrvr.com (unknown [184.106.73.70]) by smtp16.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTPS id 74130C029D; Wed, 21 Nov 2018 09:04:40 -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); Wed, 21 Nov 2018 09:04:40 -0500 Received: from MBX01D-ORD1.mex09.mlsrvr.com (172.29.128.27) by MBX01C-ORD1.mex09.mlsrvr.com (172.29.128.20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1466.3; Wed, 21 Nov 2018 08:04:39 -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; Wed, 21 Nov 2018 08:04:39 -0600 From: David Modica To: Ravi Krishna CC: "pgsql-admin@postgresql.org" Subject: RE: inserts take longer and longer Thread-Topic: inserts take longer and longer Thread-Index: AdSA6FaSSO61egjRT9+Avtk8bBh1aQACQRAAACxqbbA= Date: Wed, 21 Nov 2018 14:04:39 +0000 Message-ID: References: <9a645d6c8749483c90f5f109889ea8ce@imaginesoftware.com> In-Reply-To: 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 c3RyYWlnaHQgaW5zZXJ0IGRvaW5nIGJhdGNoZXMgb2YgMTAwLiBkcm9wcGluZyB0aGUgaW5kZXgg dG8gc2VlIGlmIHRoYXQgaGVscHMuDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9t OiBSYXZpIEtyaXNobmEgPHNya3Jpc2huYUBvdXRsb29rLmNvbT4gDQpTZW50OiBUdWVzZGF5LCBO b3ZlbWJlciAyMCwgMjAxOCAxMTo1MiBBTQ0KVG86IERhdmlkIE1vZGljYSA8ZGF2aWRtb0BpbWFn aW5lc29mdHdhcmUuY29tPg0KQ2M6IHBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0 OiBSZTogaW5zZXJ0cyB0YWtlIGxvbmdlciBhbmQgbG9uZ2VyDQoNCj4gDQo+IHdlIGhhdmUgYSBk ZXZlbG9wZXIgd2hvIGlzIGRvaW5nDQo+IGJhdGNoIGluc2VydHMgMjAgYXQgYSB0aW1lIGFuZCBl YWNoIHN1YnNlcXVlbnQgYmF0Y2ggaXMgdGFraW5nIGxvbmdlciANCj4gdG8gdGhlIHBvaW50IHdo ZXJlIGl0IGlzIGEgY3JpdGljYWwgcHJvYmxlbS4gSSByZWNlbnRseSBjaGFuZ2VkIHRoZSANCj4g b3V0IG9mIHRoZSBib3ggY29uZmlnIHRvIHNlZSBpZiB0aGF0IHdvdWxkIGhlbHAgYnV0IGl0IGhh c27igJl0Og0KPiANCg0KSSByZWNvbGxlY3QgcmVhZGluZyBzb21ldGhpbmcgZmV3IHllYXJzIGFn bywgYnV0IG5vdCBhYmxlIHRvIHBsYWNlIG15IGZpbmdlciBvbiB0aGUgaXNzdWUuIElJUkMgaXQg d2FzIHNvbWV0aGluZyB0byBkbyB3aXRoIHRoZSBpbnNlcnRpbmcgc2Vzc2lvbiBjcmVhdGluZyBh IEhPVCBibG9hdCBiZWNhdXNlIHZhY2N1bSBjb3VsZCBub3QgZG8gYW55dGhpbmcgb24gdGhhdCBs aXZlIHNlc3Npb24uICBJIHdpbGwgdHJ5IHRvIHNlYXJjaCBmb3IgdGhhdCBwb3N0LiAgQnV0IHRo ZSBzeW1wdG9tcyB3ZXJlIHNpbWlsYXIgdG8geW91cnMuICBJbml0aWFsbHkgZ29vZCBwZXJmb3Jt YW5jZSBhbmQgdGhlbiBnZXR0aW5nIHNsb3dlciBhbmQgc2xvd2VyLg0KDQpROiBJcyBpdCBzdHJh aWdodCBpbnNlcnQgb3IgeW91IGRvIHNlbGVjdCBvciB1cGRhdGVzIGFsc28gYWxvbmcgd2l0aCBp bnNlcnQuDQo=