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 1gPTJ5-0006i9-A6 for pgsql-admin@arkaria.postgresql.org; Wed, 21 Nov 2018 14:16:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gPTJ3-00013m-Uh for pgsql-admin@arkaria.postgresql.org; Wed, 21 Nov 2018 14:16:41 +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 1gPT6S-0005su-Hr for pgsql-admin@lists.postgresql.org; Wed, 21 Nov 2018 14:03:41 +0000 Received: from smtp66.ord1c.emailsrvr.com ([108.166.43.66]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPT6N-0003Px-Pf for pgsql-admin@postgresql.org; Wed, 21 Nov 2018 14:03:38 +0000 Received: from smtp9.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp9.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id 6A4322047B; Wed, 21 Nov 2018 09:03:34 -0500 (EST) X-SMTPDoctor-Processed: csmtpprox beta Received: from smtp9.relay.ord1c.emailsrvr.com (localhost [127.0.0.1]) by smtp9.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id 66CED2048B; Wed, 21 Nov 2018 09:03:34 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=imaginesoftware.com; s=20170104; t=1542809014; bh=S9JDZeZcalhJqeGwe8UTGaZSsYNhLAWez9qa0DLntQY=; h=From:To:Subject:Date:From; b=a2BdEn+bez00QIL3PLK2U5shgkw4DWjdByo7K9LB9vsBvAwL7BKPvXyDA5smPWS2J hMgFSWve5A8uiKDbb1jHhBIss6SllRLHiNAglZxYakojcs4hyQQSNVAiqAIr5VWvPd F31Zk7nQIX3eia56NRpXW7iDmH215vSn6mI37ehg= Received: from smtp192.mex09.emailsrvr.com (unknown [184.106.73.70]) by smtp9.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTPS id 3AA072047B; Wed, 21 Nov 2018 09:03:34 -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:03:34 -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:03:33 -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:03:33 -0600 From: David Modica To: =?utf-8?B?U3TDqXBoYW5lIEtBTlNDSElORQ==?= CC: "pgsql-admin@postgresql.org" Subject: RE: inserts take longer and longer Thread-Topic: inserts take longer and longer Thread-Index: AdSA6FaSSO61egjRT9+Avtk8bBh1aQAOcdCAACAziuA= Date: Wed, 21 Nov 2018 14:03:33 +0000 Message-ID: <2f1c29c8d9f54f5a9f996582c5f75c48@imaginesoftware.com> References: <9a645d6c8749483c90f5f109889ea8ce@imaginesoftware.com> <20181120164103.plefj3qzvgt6pd53@office.hexack.fr> In-Reply-To: <20181120164103.plefj3qzvgt6pd53@office.hexack.fr> 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 d2Ugd2lsbCB0cnkgdGhhdCBhbmQgc2VlIGlmIGl0IGhlbHBzLg0KDQotLS0tLU9yaWdpbmFsIE1l c3NhZ2UtLS0tLQ0KRnJvbTogU3TDqXBoYW5lIEtBTlNDSElORSA8c3RlcGhhbmVAaGV4YWNrLmZy PiANClNlbnQ6IFR1ZXNkYXksIE5vdmVtYmVyIDIwLCAyMDE4IDExOjQxIEFNDQpUbzogRGF2aWQg TW9kaWNhIDxkYXZpZG1vQGltYWdpbmVzb2Z0d2FyZS5jb20+DQpDYzogcGdzcWwtYWRtaW5AcG9z dGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBpbnNlcnRzIHRha2UgbG9uZ2VyIGFuZCBsb25nZXIN Cg0KTGUgbWFyLiAyMCBub3YuLCB2ZXJzIDE1OjU1LCBEYXZpZCBNb2RpY2EgZXhwcmltYWl0IDoN Cg0KPiBoaSBhbGwuIA0KDQpIaSwNCg0KPiBJIGhvcGUgdGhpcyBpcyB0aGUgY29ycmVjdCB3YXkg dG8gZ2V0IGhlbHAgZnJvbSB0aGUgbGlzdC4NClsuLi5dDQo+IHdlIGhhdmUgYSBkZXZlbG9wZXIg d2hvIGlzIGRvaW5nIGJhdGNoIGluc2VydHMgMjAgYXQgYSB0aW1lIGFuZCBlYWNoIA0KPiBzdWJz ZXF1ZW50IGJhdGNoIGlzIHRha2luZyBsb25nZXIgdG8gdGhlIHBvaW50IHdoZXJlIGl0IGlzIGEg Y3JpdGljYWwgDQo+IHByb2JsZW0uIEkgcmVjZW50bHkgY2hhbmdlZCB0aGUgb3V0IG9mIHRoZSBi b3ggY29uZmlnIHRvIHNlZSBpZiB0aGF0IA0KPiB3b3VsZCBoZWxwIGJ1dCBpdCBoYXNu4oCZdDoN ClsuLi5dDQo+IGFueSBkaXJlY3Rpb24gYXMgdG8gd2hhdCB0byBsb29rIGF0IHdvdWxkIGJlIGFw cHJlY2lhdGVkLg0KDQpXaGVuIHlvdSdyZSBkb2luZyBidWxrIGluc2VydCwgaXQncyBhIGdvb2Qg cHJhY3RpY2UgdG8gZHJvcCBpbmRleCBhbmQgcmVjcmVhdGUgaXQgYWZ0ZXIuDQoNClJlZ2FyZHMs DQotLQ0KU3TDqXBoYW5lIEtBTlNDSElORSAtIGh0dHBzOi8vd3d3LmhleGFjay5mci4vIC0gaHR0 cHM6Ly93d3cubnVhamlrLmlvLi8NCu+8oCBzdGVwaGFuZUBoZXhhY2suZnINCu6IgSAgKzMzIDYg NjQgMzEgNzIgNTINCg==