Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dfVmB-0007Ok-QS for pgsql-performance@arkaria.postgresql.org; Wed, 09 Aug 2017 18:32:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dfVmB-0007ZD-D0 for pgsql-performance@arkaria.postgresql.org; Wed, 09 Aug 2017 18:32:15 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dfVkN-0002Se-OR for pgsql-performance@postgresql.org; Wed, 09 Aug 2017 18:30:23 +0000 Received: from mail-by2nam03on0050.outbound.protection.outlook.com ([104.47.42.50] helo=NAM03-BY2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dfVkE-0007Fd-TB for pgsql-performance@postgresql.org; Wed, 09 Aug 2017 18:30:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=NETORG2528281.onmicrosoft.com; s=selector1-laurenthasson-com01i; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=fOL8HKQcavYgQEZPQK+5+AUW4nsH3TrXzxRZwQeeUqc=; b=oarbT/4vDqMGfiPSESa/BdXPAM/jjtGbzIkvvK510aEIK4JdYba35dst1DGVCiDUG5nAyrVoPBIOrgKlPC9XV44MMnhP42XqcyMQj5crlKer6z/Cxu3Hk+C3FpstzSuUo779bkV8WVqJ4/k1m4tRe0tH3E5bCrxR6fmUb7iIBIM= Received: from BN4PR15MB0547.namprd15.prod.outlook.com (10.164.61.157) by BN4PR15MB0548.namprd15.prod.outlook.com (10.164.61.158) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.1.1320.16; Wed, 9 Aug 2017 18:30:10 +0000 Received: from BN4PR15MB0547.namprd15.prod.outlook.com ([10.164.61.157]) by BN4PR15MB0547.namprd15.prod.outlook.com ([10.164.61.157]) with mapi id 15.01.1320.018; Wed, 9 Aug 2017 18:30:10 +0000 From: "ldh@laurent-hasson.com" To: George Neuner , postgres performance list Subject: Re: Unlogged tables Thread-Topic: [PERFORM] Unlogged tables Thread-Index: AQHTETt/Lq7x/1InREuLnDINR7olQqJ8WJmS Date: Wed, 9 Aug 2017 18:30:10 +0000 Message-ID: References: <314ce53a-ee57-0be3-7815-f0e99fc0a6e4@comcast.net> In-Reply-To: <314ce53a-ee57-0be3-7815-f0e99fc0a6e4@comcast.net> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=ldh@laurent-hasson.com; x-originating-ip: [107.77.234.34] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;BN4PR15MB0548;6:BipjzAAFv+mqrOZP7XT+avgiuRpOOiaHq77e/oqLtQkKIJcHwqQsPmaJz3Rw2+MN+EUe1py7PaRLoVe2lxzHTCqsiu68lHVzwxE7IA+WDgZW/D2TEWEi8YIZUGP/NJMlklAL4q4nHAyfMMXy/ZcM9bNpTdM4mo0J3gpXy4laaT1F/NU2N3wp0UN3Ri7Hox8IKBbe1Iyf+AtiwD1Uf0BjrW+lJSNjqqiDWb+KfLW2vAN5H60BKk4sbzl59r5852XPEsXax88kMSeTL1G1HLhVu6SDME6b3rPLUoxpNyUHD19pUSgYm0XbaLcYE7hLQ2EcKRjPCMhzcL3D4/yCarHo2w==;5:vOD7Tal9NGOYdSkVSUxXQcwDr/ruMgzeytEBKJYSsbh7Ha+ud+DMOPjT8OA9fg2asPw493VjBhcWzJMptRCJMidaeaDcM0mQBx0zxjLO6wo3EZ6JuW57kYVd5zbWyGs5SAxpbLAaF6ltY8CwexJfIg==;24:k/RPmnnMvpVnSvMGqBrEhCCVAKS1b01ihh93v5lYZWw2aIf3nytrE5cIKxKdlzWRZyjadWz9kP4mfJdRerFESTGKV2kp32Ujcr/172rGpHw=;7:ib5spXQ8LZDaTrc9yATlyIu2cm2NxxCf34U1e5qrWCu35KUhOPlCLZQULH5Vt0TCRI2N3XFVtYkaDGx6eiYZGgEPg8qbrnJGTwsxmIua0lZz+DBHV62BW1iNLJd1eIONGbF26ll0iaHP1WCSwqMeypJ7ePLQ/pvlKpYVD481vQe3LAxlt1GBVQ9G2QYnO5T3o2Qy+p7YcdSXyDl8FYSlWPdczHj50//eiopjU1m3+PY= x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-correlation-id: b20e0f1d-126f-4d33-066d-08d4df54ab45 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(300000500095)(300135000095)(300000501095)(300135300095)(22001)(300000502095)(300135100095)(2017030254152)(2017082002075)(300000503095)(300135400095)(2017052603031)(201703131423075)(201702281549075)(300000504095)(300135200095)(300000505095)(300135600095)(300000506095)(300135500095);SRVR:BN4PR15MB0548; x-ms-traffictypediagnostic: BN4PR15MB0548: x-exchange-antispam-report-test: UriScan:(68173958961439)(101568727142576); x-microsoft-antispam-prvs: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(6040450)(601004)(2401047)(5005006)(8121501046)(93006095)(93001095)(100000703101)(100105400095)(10201501046)(3002001)(6041248)(20161123560025)(20161123564025)(201703131423075)(201703061421075)(2016111802025)(20161123555025)(20161123558100)(20161123562025)(6072148)(6043046)(201708071742011)(100000704101)(100105200095)(100000705101)(100105500095);SRVR:BN4PR15MB0548;BCL:0;PCL:0;RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095);SRVR:BN4PR15MB0548; x-forefront-prvs: 0394259C80 x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(39400400002)(39450400003)(199003)(189002)(24454002)(50986999)(54356999)(8676002)(105586002)(6306002)(8666007)(102836003)(6116002)(54896002)(6436002)(606006)(236005)(3846002)(53546010)(9686003)(106356001)(55016002)(6246003)(5660300001)(66066001)(508600001)(38730400002)(53936002)(99286003)(33656002)(2900100001)(101416001)(77096006)(81156014)(6506006)(68736007)(7736002)(8936002)(3660700001)(2950100002)(76176999)(229853002)(2906002)(97736004)(81166006)(14454004)(86362001)(25786009)(74316002)(966005)(86582002)(7696004)(189998001)(3280700002)(19623405001);DIR:OUT;SFP:1101;SCL:1;SRVR:BN4PR15MB0548;H:BN4PR15MB0547.namprd15.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; received-spf: None (protection.outlook.com: laurent-hasson.com does not designate permitted sender hosts) spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_BN4PR15MB0547F5864AD9691E31458FE1858B0BN4PR15MB0547namp_" MIME-Version: 1.0 X-OriginatorOrg: laurent-hasson.com X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Aug 2017 18:30:10.5225 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 7f9c0a0d-79fd-4329-b129-754c4501a177 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN4PR15MB0548 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --_000_BN4PR15MB0547F5864AD9691E31458FE1858B0BN4PR15MB0547namp_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 T2ssIEkgYW0gbm90IHN1cmUuIEkgcnVuIFBvc3RncmVzIGFzIGEgc2VydmljZSwgYW5kIHdoZW4g bXkgV2luZG93cyByZWJvb3RlZCBhZnRlciBhIHBhdGNoLCBVTkxPR0dFRCB0YWJsZXMgd2VyZSBj bGVhbmVkLi4uIG1heWJlIHRoZSBwYXRjaCBwcm9jZXNzIGluIFdpbmRvd3MgbWVzc2VkIHNvbWV0 aGluZyB1cCwgSSBkb24ndCBrbm93Lg0KDQpGcm9tOiBnbmV1bmVyMkBjb21jYXN0Lm5ldA0KU2Vu dDogQXVndXN0IDksIDIwMTcgMTM6MTcNClRvOiBwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3Fs Lm9yZw0KU3ViamVjdDogUmU6IFtQRVJGT1JNXSBVbmxvZ2dlZCB0YWJsZXMNCg0KDQpPbiBXZWQs IDkgQXVnIDIwMTcgMDk6MTQ6NDggLTA3MDAsIEplZmYgSmFuZXMgPGplZmYuamFuZXNAZ21haWwu Y29tPiB3cm90ZToNCg0KID5XaHkgZG9lc24ndCB0aGUgV2luZG93cyBzY2hlZHVsZWQgc2h1dGRv d24gc2lnbmFsIHBvc3RncmVzIHRvIHNodXRkb3duDQogPmNsZWFubHkgYW5kIHdhaXQgZm9yIGl0 IHRvIGRvIHNvPyAgVGhhdCBpcyB3aGF0IGlzIHN1cHBvc2VkIHRvIGhhcHBlbi4NCg0KV2luZG93 cyAqZG9lcyogc2lnbmFsIHNodXRkb3duIChhbmQgc2xlZXAgYW5kIGhpYmVybmF0ZSBhbmQgd2Fr ZXVwKS4NCnBnX2N0bCBjYW4gY2F0Y2ggdGhlc2Ugc2lnbmFscyBvbmx5IHdoZW4gcnVubmluZyBh cyBhIHNlcnZpY2UgLi4uIGl0DQp3aWxsIG5vdCBjYXRjaCBhbnkgc3lzdGVtIHNpZ25hbHMgd2hl biBydW4gYXMgYW4gYXBwbGljYXRpb24uDQoNCkdlb3JnZQ0KDQoNCi0tDQpTZW50IHZpYSBwZ3Nx bC1wZXJmb3JtYW5jZSBtYWlsaW5nIGxpc3QgKHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwu b3JnKQ0KVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOg0KaHR0cDovL3d3dy5w b3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1wZXJmb3JtYW5jZQ0K --_000_BN4PR15MB0547F5864AD9691E31458FE1858B0BN4PR15MB0547namp_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtU2Vj dXJpdHktUG9saWN5IiBjb250ZW50PSJzY3JpcHQtc3JjICdzZWxmJzsgaW1nLXNyYyAqIGNpZDog ZGF0YTo7Ij4NCjwvaGVhZD4NCjxib2R5IHN0eWxlPSJiYWNrZ3JvdW5kLWNvbG9yOiByZ2IoMjU1 LCAyNTUsIDI1NSk7IGJhY2tncm91bmQtaW1hZ2U6IGluaXRpYWw7IGxpbmUtaGVpZ2h0OiBpbml0 aWFsOyI+DQo8ZGl2IGlkPSJyZXNwb25zZV9jb250YWluZXJfQkJQUElEIiBzdHlsZT0ib3V0bGlu ZTpub25lO2ZvbnQtc2l6ZTppbml0aWFsO2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDss JnF1b3Q7U2xhdGUgUHJvJnF1b3Q7LHNhbnMtc2VyaWYsJnF1b3Q7c2Fucy1zZXJpZiZxdW90OyIg ZGlyPSJhdXRvIiBjb250ZW50ZWRpdGFibGU9ImZhbHNlIj4NCjxkaXYgbmFtZT0iQkIxMCIgZGly PSJhdXRvIiBzdHlsZT0id2lkdGg6IDEwMCU7IHBhZGRpbmc6IGluaXRpYWw7IGZvbnQtc2l6ZTog aW5pdGlhbDsgdGV4dC1hbGlnbjogaW5pdGlhbDsgYmFja2dyb3VuZC1jb2xvcjogcmdiKDI1NSwg MjU1LCAyNTUpOyI+DQo8ZGl2IG5hbWU9IkJCMTAiIGlkPSJCQjEwX3Jlc3BvbnNlX2Rpdl9CQlBQ SUQiIGRpcj0iYXV0byIgc3R5bGU9ImZvbnQtZmFtaWx5OiBDYWxpYnJpLCAmcXVvdDtTbGF0ZSBQ cm8mcXVvdDssIHNhbnMtc2VyaWYsIHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogaW5pdGlhbDsgdGV4 dC1hbGlnbjogaW5pdGlhbDsgd2lkdGg6IDM4MHB4OyBwYWRkaW5nOiBpbml0aWFsOyI+DQpPaywg SSBhbSBub3Qgc3VyZS4gSSBydW4gUG9zdGdyZXMgYXMgYSBzZXJ2aWNlLCBhbmQgd2hlbiBteSBX aW5kb3dzIHJlYm9vdGVkIGFmdGVyIGEgcGF0Y2gsIFVOTE9HR0VEIHRhYmxlcyB3ZXJlIGNsZWFu ZWQuLi4gbWF5YmUgdGhlIHBhdGNoIHByb2Nlc3MgaW4gV2luZG93cyBtZXNzZWQgc29tZXRoaW5n IHVwLCBJIGRvbid0IGtub3cuPC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rp dj4NCjxkaXYgaWQ9Il9vcmlnaW5hbF9tc2dfaGVhZGVyX0JCUFBJRCIgZGlyPSJhdXRvIj4NCjx0 YWJsZSB3aWR0aD0iMTAwJSIgc3R5bGU9ImJhY2tncm91bmQtY29sb3I6IHdoaXRlOyBib3JkZXIt c3BhY2luZzogMHB4OyBkaXNwbGF5OiB0YWJsZTsgb3V0bGluZTogbm9uZTsiIGNvbnRlbnRlZGl0 YWJsZT0iZmFsc2UiPg0KPHRib2R5Pg0KPHRyPg0KPHRkIGNvbHNwYW49IjIiIHN0eWxlPSJwYWRk aW5nOiBpbml0aWFsOyBmb250LXNpemU6IGluaXRpYWw7IHRleHQtYWxpZ246IGluaXRpYWw7IGJh Y2tncm91bmQtY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPg0KPGRpdiBkYXRhLWhhcy1pbmxp bmUtZWRpdHM9IiIgc3R5bGU9ImJvcmRlci1yaWdodDogbm9uZTsgYm9yZGVyLWJvdHRvbTogbm9u ZTsgYm9yZGVyLWxlZnQ6IG5vbmU7IGJvcmRlci1pbWFnZTogaW5pdGlhbDsgYm9yZGVyLXRvcDog MXB0IHNvbGlkIHJnYigxODEsIDE5NiwgMjIzKTsgcGFkZGluZzogM3B0IDBpbiAwaW47IGZvbnQt ZmFtaWx5OiBUYWhvbWEsICZxdW90O0JCIEFscGhhIFNhbnMmcXVvdDssICZxdW90O1NsYXRlIFBy byZxdW90OzsgZm9udC1zaXplOiAxMHB0OyI+DQo8ZGl2IGlkPSJmcm9tIj48Yj5Gcm9tOjwvYj4g Z25ldW5lcjJAY29tY2FzdC5uZXQ8L2Rpdj4NCjxkaXYgaWQ9InNlbnQiPjxiPlNlbnQ6PC9iPiBB dWd1c3QgOSwgMjAxNyAxMzoxNzwvZGl2Pg0KPGRpdiBpZD0idG8iPjxiPlRvOjwvYj4gcGdzcWwt cGVyZm9ybWFuY2VAcG9zdGdyZXNxbC5vcmc8L2Rpdj4NCjxkaXYgaWQ9InN1YmplY3QiPjxiPlN1 YmplY3Q6PC9iPiBSZTogW1BFUkZPUk1dIFVubG9nZ2VkIHRhYmxlczwvZGl2Pg0KPC9kaXY+DQo8 L3RkPg0KPC90cj4NCjwvdGJvZHk+DQo8L3RhYmxlPg0KPGRpdiBzdHlsZT0iYm9yZGVyLXJpZ2h0 OiBub25lOyBib3JkZXItYm90dG9tOiBub25lOyBib3JkZXItbGVmdDogbm9uZTsgYm9yZGVyLWlt YWdlOiBpbml0aWFsOyBib3JkZXItdG9wOiAxcHQgc29saWQgcmdiKDE4NiwgMTg4LCAyMDkpOyBk aXNwbGF5OiBibG9jazsgcGFkZGluZzogaW5pdGlhbDsgZm9udC1zaXplOiBpbml0aWFsOyB0ZXh0 LWFsaWduOiBpbml0aWFsOyBiYWNrZ3JvdW5kLWNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4N CjwvZGl2Pg0KPGJyPg0KPC9kaXY+DQo8IS0tc3RhcnQgb2YgX29yaWdpbmFsQ29udGVudCAtLT4N CjxkaXYgbmFtZT0iQkIxMCIgZGlyPSJhdXRvIiBzdHlsZT0iYmFja2dyb3VuZC1pbWFnZTogaW5p dGlhbDsgbGluZS1oZWlnaHQ6IGluaXRpYWw7IG91dGxpbmU6IG5vbmU7IiBjb250ZW50ZWRpdGFi bGU9ImZhbHNlIj4NCjxkaXYgaWQ9InNzYy0zMDQ4MTE2MjU0MDQ5MzYxMjA2Ij48c3R5bGU+I3Nz Yy0zMDQ4MTE2MjU0MDQ5MzYxMjA2IC5FbWFpbFF1b3Rle21hcmdpbi1sZWZ0OiAxcHQ7cGFkZGlu Zy1sZWZ0OiA0cHQ7Ym9yZGVyLWxlZnQ6IHJnYigxMjgsIDAsIDApIDJweCBzb2xpZDt9PC9zdHls ZT4NCjxkaXY+PGZvbnQgc2l6ZT0iMiI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMHB0Ij4NCjxk aXYgY2xhc3M9IlBsYWluVGV4dCI+T24gV2VkLCA5IEF1ZyAyMDE3IDA5OjE0OjQ4IC0wNzAwLCBK ZWZmIEphbmVzICZsdDtqZWZmLmphbmVzQGdtYWlsLmNvbSZndDsgd3JvdGU6PGJyPg0KPGJyPg0K Jm5ic3A7Jmd0O1doeSBkb2Vzbid0IHRoZSBXaW5kb3dzIHNjaGVkdWxlZCBzaHV0ZG93biBzaWdu YWwgcG9zdGdyZXMgdG8gc2h1dGRvd248YnI+DQombmJzcDsmZ3Q7Y2xlYW5seSBhbmQgd2FpdCBm b3IgaXQgdG8gZG8gc28/Jm5ic3A7IFRoYXQgaXMgd2hhdCBpcyBzdXBwb3NlZCB0byBoYXBwZW4u PGJyPg0KPGJyPg0KV2luZG93cyAqZG9lcyogc2lnbmFsIHNodXRkb3duIChhbmQgc2xlZXAgYW5k IGhpYmVybmF0ZSBhbmQgd2FrZXVwKS4mbmJzcDsgPGJyPg0KcGdfY3RsIGNhbiBjYXRjaCB0aGVz ZSBzaWduYWxzIG9ubHkgd2hlbiBydW5uaW5nIGFzIGEgc2VydmljZSAuLi4gaXQgPGJyPg0Kd2ls bCBub3QgY2F0Y2ggYW55IHN5c3RlbSBzaWduYWxzIHdoZW4gcnVuIGFzIGFuIGFwcGxpY2F0aW9u Ljxicj4NCjxicj4NCkdlb3JnZTxicj4NCjxicj4NCjxicj4NCi0tIDxicj4NClNlbnQgdmlhIHBn c3FsLXBlcmZvcm1hbmNlIG1haWxpbmcgbGlzdCAocGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdyZXNx bC5vcmcpPGJyPg0KVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOjxicj4NCjxh IGhyZWY9Imh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtcGVyZm9ybWFu Y2UiPmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtcGVyZm9ybWFuY2U8 L2E+PGJyPg0KPC9kaXY+DQo8L3NwYW4+PC9mb250PjwvZGl2Pg0KPC9kaXY+DQo8IS0tZW5kIG9m IF9vcmlnaW5hbENvbnRlbnQgLS0+PC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_BN4PR15MB0547F5864AD9691E31458FE1858B0BN4PR15MB0547namp_--