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 1h9A4b-00006P-Me for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Mar 2019 15:02:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9A4a-0006zM-B7 for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Mar 2019 15:02:36 +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 1h9A4Z-0006zE-VM for pgsql-hackers@lists.postgresql.org; Wed, 27 Mar 2019 15:02:36 +0000 Received: from smtp3.omnicell.com ([173.254.187.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9A4X-0003H1-D0 for pgsql-hackers@lists.postgresql.org; Wed, 27 Mar 2019 15:02:34 +0000 Received: from pps.filterd (COLO-PP-A1.omnicell.com [127.0.0.1]) by COLO-PP-A1.omnicell.com (8.16.0.27/8.16.0.27) with SMTP id x2RF1CCd021260 for ; Wed, 27 Mar 2019 08:02:31 -0700 Received: from rtp-ex16-01.omnicell.com (RTP-EX16-01.omnicell.com [10.19.7.22]) by COLO-PP-A1.omnicell.com with ESMTP id 2rfvpga253-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Wed, 27 Mar 2019 08:02:30 -0700 From: Reid Thompson To: "pgsql-hackers@lists.postgresql.org" Subject: Re: PostgreSQL pollutes the file system Thread-Topic: PostgreSQL pollutes the file system Thread-Index: AQHU5KFq0yIGaVUkRUGd7VjaxCmfl6YfwhYAgAAEggCAAA9WgA== Date: Wed, 27 Mar 2019 15:02:29 +0000 Message-ID: References: <754d8607-682e-6f59-6870-faee5fa0820c@2ndquadrant.com> <20190321.084132.2186284141219540889.t-ishii@sraoss.co.jp> <20190321004919.GE20192@paquier.xyz> <10036.1553176960@sss.pgh.pa.us> <20190322003611.GK20192@paquier.xyz> <31754.1553220346@sss.pgh.pa.us> <3edd2644-eaf2-41e0-aa7a-92786d25b29c@catalyst.net.nz> <20190327135116.GA17983@development> <044a865f-c0c2-70e4-f4d0-ec841d701fda@proxel.se> In-Reply-To: <044a865f-c0c2-70e4-f4d0-ec841d701fda@proxel.se> Reply-To: Reid Thompson Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Evolution 3.32.1 x-originating-ip: [10.3.28.28] Content-Type: text/plain; charset="utf-8" Content-ID: <6F30B065995D524898D8E888FD882A22@omnicell.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2019-03-27_10:,, signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 priorityscore=1501 malwarescore=0 suspectscore=0 phishscore=0 bulkscore=0 spamscore=0 clxscore=1011 lowpriorityscore=0 mlxscore=0 impostorscore=0 mlxlogscore=999 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1810050000 definitions=main-1903270106 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gV2VkLCAyMDE5LTAzLTI3IGF0IDE1OjA3ICswMTAwLCBBbmRyZWFzIEthcmxzc29uIHdyb3Rl Og0KPiBbRVhURVJOQUwgU09VUkNFXQ0KPiANCj4gDQo+IA0KPiBPbiAzLzI3LzE5IDI6NTEgUE0s IFRvbWFzIFZvbmRyYSB3cm90ZToNCj4gPiBJIHRoaW5rIHRoZSBjb25zZW5zdXMgaW4gdGhpcyB0 aHJlYWQgKGFuZCB0aGUgcHJldmlvdXMgYW5jaWVudCBvbmVzKSBpcw0KPiA+IHRoYXQgaXQncyBu b3Qgd29ydGggaXQuIEl0J3Mgb25lIHRoaW5nIHRvIGludHJvZHVjZSBuZXcgY29tbWFuZHMgd2l0 aCB0aGUNCj4gPiBwZ18gcHJlZml4LCBhbmQgaXQncyBhIGNvbXBsZXRlbHkgZGlmZmVyZW50IHRo aW5nIHRvIHJlbmFtZSBleGlzdGluZyBvbmVzLg0KPiA+IFRoYXQgaGFzIGluaGVyZW50IGNvc3Rz LCBhbmQgYXMgVG9tIHBvaW50ZWQgb3V0IHRoZSBidXJkZW4gd291bGQgZmFsbCBvbg0KPiA+IHBl b3BsZSB1c2luZyBQb3N0Z3JlU1FMIChhbmQgdGhhdCdzIHJhdGhlciB1bmRlc2lyYWJsZSkuDQo+ ID4gDQo+ID4gSSBwZXJzb25hbGx5IGRvbid0IHNlZSB3aHkgaGF2aW5nIGNvbW1hbmRzIHdpdGhv dXQgcGdfIHByZWZpeCB3b3VsZCBiZQ0KPiA+IGFuIGlzc3VlLiBFc3BlY2lhbGx5IHdoZW4gcGxh Y2VkIGluIGEgc2VwYXJhdGUgZGlyZWN0b3J5LCB3aGljaCBlbGltaW5hdGVzDQo+ID4gdGhlIHBv c3NpYmlsaXR5IG9mIGNvbmZsaWN0IHdpdGggb3RoZXIgY29tbWFuZHMuDQo+IA0KPiBJIGJ1eSB0 aGF0IGl0IG1heSBub3QgYmUgd29ydGggYnJlYWtpbmcgdGVucyBvZiB0aG91c2FuZHMgb2Ygc2Ny aXB0cyB0bw0KPiBmaXggdGhpcywgYnV0IEkgZGlzYWdyZWUgYWJvdXQgaXQgbm90IGJlaW5nIGFu IGlzc3VlLiBNb3N0IExpbnV4DQo+IGRpc3RyaWJ1dGlvbnMgYWRkIFBvc3RncmVTUUwncyBleGVj dXRhYmxlcyBpbiB0byBhIGRpcmVjdG9yeSB3aGljaCBpcyBpbg0KPiB0aGUgZGVmYXVsdCAkUEFU SCAoL3Vzci9iaW4gaW4gdGhlIGNhc2Ugb2YgRGViaWFuKS4gQW5kIGV2ZW4gaWYgaXQgd291bGQN Cj4gYmUgaW5zdGFsbGVkIGludG8gYSBzZXBhcmF0ZSBkaXJlY3RvcnkgdGhlcmUgd291bGQgc3Rp bGwgYmUgYSBjb25mbGljdA0KPiBhcyBzb29uIGFzIHRoYXQgZGlyZWN0b3J5IGlzIGFkZGVkIHRv ICRQQVRILg0KPiANCj4gQW5kIEkgdGhpbmsgdGhhdCBpdCBpcyBhbHNvIHJlbGF0aXZlbHkgZWFz eSB0byBjb25mdXNlIGFkZHVzZXIgYW5kDQo+IGNyZWF0ZXVzZXIgd2hlbiByZWFkaW5nIGEgc2Ny aXB0LiBOb3RoaW5nIGFib3V0IHRoZSBuYW1lIGNyZWF0ZXVzZXINCj4gaW5kaWNhdGVzIHRoYXQg aXQgd2lsbCBjcmVhdGUgYSByb2xlIGluIGFuIFNRTCBkYXRhYmFzZS4NCj4gDQo+IEFuZHJlYXMN Cj4gDQoNCnRoZXJlcyBub3RoaW5nIGFib3V0IGNyZWF0ZXVzZXIgb3IgYWRkdXNlciggdXNlcmFk ZCBvbiBteSBzeXN0ZW0sDQphZGR1c2VyIGRvZXNuJ3QgZXhpc3Qgb24gbWluZSApIHRoYXQgaW5k aWNhdGVzIHRoYXQgZWl0aGVyIHdvdWxkL3Nob3VsZA0KY3JlYXRlIGEgdXNlciBpbiB0aGUgc3lz dGVtIGVpdGhlci4gIFRoYXQncyB3aGF0IG1hbiBhbmQgLWgvLS1oZWxwIGFyZQ0KZm9yLiAgSWYg eW91IGRvbid0IGtub3cgd2hhdCBhbiBleGVjdXRhYmxlIGRvZXMsIGRvbid0IGludm9rZSBpdCB1 bnRpbA0KeW91IGRvLiAgVGhhdCdzIGEgYmFzaWMgcHJlbWlzZSBmb3IgYW55IGV4ZWN1dGFibGUu DQoNCnJlaWQNCg0K