Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mlX7O-0005Z8-7T for pgsql-docs@arkaria.postgresql.org; Fri, 12 Nov 2021 14:01:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mlX7N-000888-7i for pgsql-docs@arkaria.postgresql.org; Fri, 12 Nov 2021 14:01:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ml6dN-0001u7-Fn for pgsql-docs@lists.postgresql.org; Thu, 11 Nov 2021 09:44:41 +0000 Received: from m-out.actual-it.si ([195.250.58.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1ml6dL-0008Oy-4x for pgsql-docs@lists.postgresql.org; Thu, 11 Nov 2021 09:44:40 +0000 Received: from ACEXC1.actual.local (10.108.6.2) by ACEXC1.actual.local (10.108.6.2) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.2308.14; Thu, 11 Nov 2021 10:44:37 +0100 Received: from ACEXC1.actual.local ([fe80::6d5b:82be:eb03:1416]) by ACEXC1.actual.local ([fe80::6d5b:82be:eb03:1416%14]) with mapi id 15.01.2308.014; Thu, 11 Nov 2021 10:44:37 +0100 From: Grega Jesih To: Laurenz Albe , Bruce Momjian , "David G. Johnston" CC: Tom Lane , Pg Docs Subject: RE: text fields and performance for ETL Thread-Topic: text fields and performance for ETL Thread-Index: AQHX0LbtwJI9OtT9g0OmU8QZraFd6KvxzrGAgAAeh5CAABOHAIAAFRQt///8egCAAOFboIAAYBSAgAFdj6CAADu2gIAAAHQAgAAEMQCAAA93gIAA6rOAgAgz+cA= Date: Thu, 11 Nov 2021 09:44:37 +0000 Message-ID: <2def7f5785d042b1b4a11d6b712b39a5@actual-it.si> References: <686716cb5c4242c28e5967d9b6fcfc75@actual-it.si> <137264.1635961048@sss.pgh.pa.us> <70cf9fe110c246afb4eab054caab0c04@actual-it.si> <516dc58b80fa418091f5262879019213@actual-it.si> <20211105141712.GA19812@momjian.us> <20211105152733.GC19812@momjian.us> <12598e4d44a8bf530934e793fde9ab2743108046.camel@cybertec.at> In-Reply-To: <12598e4d44a8bf530934e793fde9ab2743108046.camel@cybertec.at> Accept-Language: sl-SI, en-US Content-Language: sl-SI X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.252.2.9] x-c2processedorg: d07a8c1a-8772-405d-8b3f-3e485b5946e7 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: Archived-At: Precedence: bulk RGVhciBNb2RlcmF0b3JzLA0KDQp3aXRoIHRoaXMgYXBwcm9hY2gsIHdoeSBkb24ndCB5b3UgZWxp bWluYXRlIGNoYXIgYW5kIHZhcmNoYXIgdGhlbiA/DQpUaGFua3MgZm9yIHRoaW5raW5nIG92ZXIu DQoNCkJSDQpHcmVnYQ0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogTGF1cmVu eiBBbGJlIDxsYXVyZW56LmFsYmVAY3liZXJ0ZWMuYXQ+DQpTZW50OiBTYXR1cmRheSwgTm92ZW1i ZXIgNiwgMjAyMSA2OjI4IEFNDQpUbzogQnJ1Y2UgTW9tamlhbiA8YnJ1Y2VAbW9tamlhbi51cz47 IERhdmlkIEcuIEpvaG5zdG9uIDxkYXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbT4NCkNjOiBHcmVn YSBKZXNpaCA8R3JlZ2EuSmVzaWhAYWN0dWFsLWl0LnNpPjsgVG9tIExhbmUgPHRnbEBzc3MucGdo LnBhLnVzPjsgUGcgRG9jcyA8cGdzcWwtZG9jc0BsaXN0cy5wb3N0Z3Jlc3FsLm9yZz4NClN1Ympl Y3Q6IFJlOiB0ZXh0IGZpZWxkcyBhbmQgcGVyZm9ybWFuY2UgZm9yIEVUTA0KDQpPbiBGcmksIDIw MjEtMTEtMDUgYXQgMTE6MjcgLTA0MDAsIEJydWNlIE1vbWppYW4gd3JvdGU6DQo+IE9uIEZyaSwg Tm92ICA1LCAyMDIxIGF0IDA3OjMyOjEyQU0gLTA3MDAsIERhdmlkIEcuIEpvaG5zdG9uIHdyb3Rl Og0KPiA+IE9uIEZyaWRheSwgTm92ZW1iZXIgNSwgMjAyMSwgQnJ1Y2UgTW9tamlhbiA8YnJ1Y2VA bW9tamlhbi51cz4gd3JvdGU6DQo+ID4NCj4gPg0KPiA+ICAgICA+DQo+ID4gICAgID4gUGVyaGFw cywgcmlnaHQgYmVmb3JlIHRoZSB0aXAgeW91IHF1b3RlZCwgc29tZXRoaW5nIGxpa2UgdGhhdDoN Cj4gPiAgICAgPg0KPiA+ICAgICA+ICAgSWYgeW91ciB1c2UgY2FzZSByZXF1aXJlcyBhIGxlbmd0 aCBsaW1pdCBvbiBjaGFyYWN0ZXIgZGF0YSwNCj4gPiBvcg0KPiA+ICAgICBjb21wbGlhbmNlDQo+ ID4gICAgID4gICB3aXRoIHRoZSBTUUwgc3RhbmRhcmQgaXMgaW1wb3J0YW50LCB1c2UgImNoYXJh Y3RlciB2YXJ5aW5nIi4NCj4gPiAgICAgPiAgIE90aGVyd2lzZSwgeW91IGFyZSB1c3VhbGx5IGJl dHRlciBvZmYgd2l0aCAidGV4dCIuDQo+ID4NCj4gPiAgICAgSSBjYW4gc3VwcG9ydCB0aGF0IGlm IG90aGVycyB0aGluayBpdCBpcyB2YWx1YWJsZS4NCj4gPg0KPiA+DQo+ID4NCj4gPiBUaGUgbW90 aXZhdGluZyBjb21wbGFpbnQgaXMgdGhhdCB3ZSBzaG91bGQgYmUgZW5jb3VyYWdpbmcgcGVvcGxl IHRvDQo+ID4gdXNlIHZhcmNoYXINCj4gPiAoNDAwMCkgaW5zdGVhZCBvZiB0ZXh0IHNvIGV4dGVy bmFsIHRvb2xzIGNhbiBvcHRpbWl6ZS4gIElmIHdlIGFyZQ0KPiA+IG5vdCBnb2luZyB0byBkbyB0 aGF0IEkgcmVhbGx5IGRvbuKAmXQgc2VlIHRoZSBwb2ludGluZyBpbiBjaGFuZ2luZw0KPiA+IGF3 YXkgZnJvbSBvdXQgY3VycmVudCBwb3NpdGlvbiBvZiDigJxvbmx5IHVzZSB0ZXh04oCdLiAgVHJ1 ZSBsZW5ndGgNCj4gPiBsaW1pdCByZXF1aXJlbWVudHMgZm9yIGRhdGEgYXJlIHJhcmUsIGFuZCBi ZXR0ZXIgZG9uZSBpbiBjb25zdHJhaW50cw0KPiA+IGFsb25nIHdpdGggYWxsIG90aGVyIHRoZSBv dGhlciBjb25zdHJhaW50IHRoYXQgbWF5IGV4aXN0IGZvciB0aGUNCj4gPiBkYXRhLiAgSSBiZWxp ZXZlIGNvbW1lbnRzIHdpdGggcmVzcGVjdCB0byB0aGUgU1FMIHN0YW5kYXJkIGFyZSBhbHJlYWR5 IHByZXNlbnQgYW5kIGFkZXF1YXRlLg0KPg0KPiBBZ3JlZWQuDQoNCisxLCBzbyBsZXQncyBsZWF2 ZSBpdCBhcyBpdCBpcy4NCg0KWW91cnMsDQpMYXVyZW56IEFsYmUNCg0KDQpOT1RJQ0UgLSBOT1Qg VE8gQkUgUkVNT1ZFRC4NClRoaXMgZS1tYWlsIGFuZCBhbnkgYXR0YWNobWVudHMgYXJlIGNvbmZp ZGVudGlhbCBhbmQgbWF5IGNvbnRhaW4gbGVnYWxseSBwcml2aWxlZ2VkIGluZm9ybWF0aW9uIGFu ZC9vciBjb3B5cmlnaHQgbWF0ZXJpYWwgb2YgQWN0dWFsIEkuVC4gb3IgdGhpcmQgcGFydGllcy4g SWYgeW91IGFyZSBub3QgYW4gYXV0aG9yaXNlZCByZWNpcGllbnQgb2YgdGhpcyBlLW1haWwsIHBs ZWFzZSBjb250YWN0IEFjdHVhbCBJLlQuIGltbWVkaWF0ZWx5IGJ5IHJldHVybiBlbWFpbCBvciBi eSB0ZWxlcGhvbmUgb3IgZmFjc2ltaWxlIG9uIHRoZSBhYm92ZSBudW1iZXJzLg0KWW91IHNob3Vs ZCBub3QgcmVhZCwgcHJpbnQsIHJlLXRyYW5zbWl0LCBzdG9yZSBvciBhY3QgaW4gcmVsaWFuY2Ug b24gdGhpcyBlbWFpbCBvciBhbnkgYXR0YWNobWVudHMgYW5kIHlvdSBzaG91bGQgZGVzdHJveSBh bGwgY29waWVzIG9mIHRoZW0uDQo=