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 1q7cfR-00069X-Ju for pgsql-general@arkaria.postgresql.org; Fri, 09 Jun 2023 14:00:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q7cfQ-0008DF-Gt for pgsql-general@arkaria.postgresql.org; Fri, 09 Jun 2023 14:00:40 +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 1q7cfP-0008D5-QK for pgsql-general@lists.postgresql.org; Fri, 09 Jun 2023 14:00:40 +0000 Received: from mail-he1eur04on2051.outbound.protection.outlook.com ([40.107.7.51] helo=EUR04-HE1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q7cfM-001ELf-Hp for pgsql-general@lists.postgresql.org; Fri, 09 Jun 2023 14:00:39 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=WYJUJitgKZmqd3A+TuCr0KVA9R1hljcWkQix6o5QOWRNSSnDgWGIZmj2leVkUTcRv/NHarQgGyTvAkm8lTBV9kQlVjYZFo0KdYzmAEKOf3YL2gYvFpAdXDtGD9VQ+6ByPZVofLh6L9qjrNAQs9kusewIrbZIq2dkJG0JbZ/xFAnZWuy+ZOI3o8mVvJs8NOP82XS2RpjV9GX09TwQEFvShVJYPnABOT57SeYr5FeUVqh2ELSIhjQf6YeHIKfTiqg0J2C7pAn0LPKEdHW+56+z525dOMb7cTyoR99Xin4FNOOZeJHQEEKaUm01vZemx5vEtMvPXpJ3xmOfrbTgmL+ZGA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=HNrsoqWtoDpPtXLDMEUselg7z8TPcp/3EIc7ZRvyYMg=; b=Zb6n26EnzHoVoTU0qDZmo1CfAPHmVA6+SQtx9HLEOHIaxhYx+Z4QMhBOkVHpQpLACcLl2h59qsH5GDEfzHx/zImIp47scdujrZgmDYXS5Aegl7ofNmAPUTsfF+eAL8xFCaEkRuf187zMWbYZk+cvN1MKD8w1dsIrIQtMVZ3yue/vm4esuBTzQM06pXfS2TCg/opPpL8hZ53lFhS6Wiq/9Ak/4dChpIis7jp+F5WX8ldyP7KQaheUdw71WHZ38d+xskjBtPerhuiZJdyCNRL7PcnQ3OhlNMMFeAJThNjzcjGCkPUWcPLKfk9K5aakOyswVAGV7+lo0yNi8BibjDSXTQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucll.be; dmarc=pass action=none header.from=ucll.be; dkim=pass header.d=ucll.be; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucll.be; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=HNrsoqWtoDpPtXLDMEUselg7z8TPcp/3EIc7ZRvyYMg=; b=JV4W/54xH8hg4l7YN4TjFrNjuTERlNcllPJCBr6bEWuLL1+ZGqyGZLW7q2S0dWyFx7WF01rVqQ/2SeAcyEQpWIHxZYC7CZRbJbr+G/kJMz+EOhbEMiSBGin6i6Eetl0Z+q2eWymJ2YqsxSOkFC0DxJS+aBH4ENcGBpcNbnd+/HA= Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:1ff::22) by VI1P195MB0703.EURP195.PROD.OUTLOOK.COM (2603:10a6:800:153::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6455.39; Fri, 9 Jun 2023 14:00:27 +0000 Received: from AM9P195MB0790.EURP195.PROD.OUTLOOK.COM ([fe80::8381:b923:d891:4301]) by AM9P195MB0790.EURP195.PROD.OUTLOOK.COM ([fe80::8381:b923:d891:4301%6]) with mapi id 15.20.6455.030; Fri, 9 Jun 2023 14:00:27 +0000 From: Wim Bertels To: "mail@joeconway.com" , "pgsql-general@lists.postgresql.org" , "pat.trainor@gmail.com" Subject: Re: How To: A large [2D] matrix, 100,000+ rows/columns Thread-Topic: How To: A large [2D] matrix, 100,000+ rows/columns Thread-Index: AQHZmnikS8wn3IsqWk6ZKmWCKFtht6+CdCIAgAAMaYA= Date: Fri, 9 Jun 2023 14:00:27 +0000 Message-ID: <4bb77358282da0509415de05079f118ef73f7033.camel@ucll.be> References: <626833f2-50e2-342c-e8ea-cb16b0d01785@joeconway.com> In-Reply-To: <626833f2-50e2-342c-e8ea-cb16b0d01785@joeconway.com> Accept-Language: nl-NL, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Evolution 3.38.3-1+deb11u2 authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=ucll.be; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AM9P195MB0790:EE_|VI1P195MB0703:EE_ x-ms-office365-filtering-correlation-id: 1e749e0b-5ab1-4b83-4ecb-08db68f1e0fb x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: y030gdV5Sb5REM6vyO+gc/XfHRFuwRewaWZeNivFYwVZmKJLyWpgBj8dchOJYkd58MyT77TRROpWifRHigdQuMY6GYdgTI08B3R7qcaf/e5DRFNGkCHDQJPew2vd8BEMl7nvElO/hzse/l9P3qQjrlXbwyEzx0+6J+ofz9sZa7Q6nfiOnec1J8a7sPpaC1WHfFQQkJEAVA01rvtRMDP03rLx64+qjiyY3NYlcnRsV4es7XufI0YK8IjIJTBsfdOR70tV0W2i7ed1tDyNk/JJiPt7kf4BhTNW7ERhE9hDZieUoQAR1kprgMKYnq6ljCt/K5ONWb5Mwe1FXA/K7QSWIdrRsz3HNi5PZ4YNpbRmnJeCYippbex4//6IhOl1Om1MsFSqzDNBcWn5cDeXIKEX5aBPd6TGFf5mxP2RWS5WzeHV3G35ZSbhbs2whEFLPWYVw36u3zD/ylaISicToC08ji9AE4eRIjyk3ISFhCf/2DE6n4KAXDRVbRv1k3EJg6/cW6TBHfW1V4wKBmi/3zZaGKDkE4CpM1TcAxjrrQraDwC3zY6ah1d3o/QFDKNZrisgnAEGU3G+hEb3EFVqEL//mZEipy0RefhRt23RvLL7QzugoAKHiRydR9hhSSKi042fThZhp16Xkuvpzsoqx750aQ== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM9P195MB0790.EURP195.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230028)(4636009)(39850400004)(376002)(366004)(396003)(346002)(136003)(451199021)(86362001)(2616005)(64756008)(83380400001)(38100700002)(5660300002)(966005)(36756003)(6486002)(44832011)(71200400001)(478600001)(122000001)(110136005)(66946007)(2906002)(66556008)(66446008)(66476007)(76116006)(186003)(316002)(786003)(41300700001)(38070700005)(53546011)(6506007)(6512007)(41320700001)(8936002)(8676002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?dHNlWUlKelp4b3djWXN2cFJPNDJzU3RiNVA3NlF3VFFXZTNzUUhJRmtrMUxi?= =?utf-8?B?TDQramFMOUxpYmxKTWNpOWNyMlZIb0lZV3Z6SUlGSnNSZDJadXRRMmRiZ3ZM?= =?utf-8?B?NWNuVkRlLzJQWWplNHJIMDJ2bGxtNW5rWnViN1lYWTVYN0hEQ3QxWXc1Wnhy?= =?utf-8?B?aUJyVnU3UlJFN3czdkdJYlMxVTJPMjhjVWZ6dVFNSzBGMnZ3YmVpWjc4dldr?= =?utf-8?B?VGhiVmNzMWxNNitzS1BOVHlGWEhvVmJyWEtsOTZFZnN0Ynl5V05RTjRPSVRo?= =?utf-8?B?c1FLMDJQUzlqUWNVNmdqeTFuOFF1U1QxRXFkV0hkNDNyVk5vVVU2VWQxV293?= =?utf-8?B?VmtEb0VwS1NQK3J2Mm52VHJ6a0h4TmlNN2h5dVRJcnJUREpYZGlsVzdTUUYy?= =?utf-8?B?ZU9yVlk2WDVwbkdTK1JGYStzTUtRYzJkMXlVYlIrT1ZKdVRjWU1rdXpOc1hO?= =?utf-8?B?VmQ4TmxtLy9hWitJK2ZTRWE4WVR4TzF2WDlucmp6YW1ZZEhVZFUzTjBkNWph?= =?utf-8?B?L1VDTUQybWo1QkgzZ2NOem1JMHg1WW9ycW1vNTlTMTVrVVcrOHUvdlZOeFJS?= =?utf-8?B?TG8xdE9LTXk1V1h5dEM4djF5Vi9yS0gzd2hiZ0RPVk1NQ3VtVnFLUzVWNGpG?= =?utf-8?B?Q3BLenhEQnlhd1pMYk1HVFVsamcrM21wSS9vYmhhRHlUMVpXM1lzZ1E5VkY0?= =?utf-8?B?S1JpNURnRWI0THNBaVdqekxtTmloZE5SNDAwdTRsWVlUenlMWnZIT25UY2dF?= =?utf-8?B?ZkV1aGE3UVYzQ25Kd1lUQlA3RWJTeGRvbi9zWDhBT2VXYi90MXFTc3pvVFE1?= =?utf-8?B?dDlJM0grcEVSemd5S3RISkcxMlQ1M2Nta3dwMWoyQnVUVHBrQ2NiSzIzSDRj?= =?utf-8?B?ajN2UUFsckU2VTBadG16bjZzNU5MZExkbFVZdk9hYVR0RCtRaTE4aTFKUytI?= =?utf-8?B?dzdTRVp3MGR1bHdSZGUwYjl3QlVjWDdSUVJ3b0ViSHlLRloyM3M1UnpnMnJU?= =?utf-8?B?bXBqVFlKSUROQzV5VFNKTEdlNUZUMTBCblhFcU5YRzBrSDUxeTZnMlNXcmZ2?= =?utf-8?B?dGpFMk5XMDhoUWNZMEZla3k0TGEyZGZQWWc2TFRuWnBObmFQdjIwV3ZhVzFE?= =?utf-8?B?RTdiZGg4QXc5VWYxN3MrQjBDOHZDVS9LM0dyak0vOVJpa2hNZE50MTY1UnBE?= =?utf-8?B?VEpSOUE1YnF1S2lYNHB6SVBINFpWQm1oK1BsTml5OGJwNm43UUJVbWtyTlN6?= =?utf-8?B?VUVnVnJYQndkMWNybTZrY08zbkNzU3NRMVFBT1VSREZlYVJEbjNzSWU1Rnpt?= =?utf-8?B?WDhUR3BHUkg5R29GTWJuU0VFcVJQejltVVVxQmJRY0xLSHM3amtwbERpUC9x?= =?utf-8?B?R2lNMjk1Q3ZhM3RtSUI3QzFlZWx2RVFwM3hPcnNKb0NndzhXYmFzaGcwY2Yy?= =?utf-8?B?Wjk2L2d3clYxQTQrdFI5N3RCNGFzZ3JPZGlnbm9SSXFzZkdsS1ZPaHM3QVNp?= =?utf-8?B?S1dmRE9LSDNUT2pmc0xET3FtS2cwUnlJTWxybzBmTjl2VFNaaXRnQWM1bUM3?= =?utf-8?B?enlOM2ovNmZMZERLUk5BTllUQlpxVHRlWVRVaS8yTU8zcVJkMHh2UWhmVzhl?= =?utf-8?B?OERwT2NaRTRmcmh5SC95L0NvbEd5SUEyaXgxalFPSXdaV1Y2eGZ3QjFLNjJE?= =?utf-8?B?ZWRtT3JRTEJuTk8wK052aXczS05wRmg0RnFTQ3JlQUZPeVhyQVNJa1pyTDJh?= =?utf-8?B?bUVHTGRQVDJnOVlDL3RUZm5BWTFaZ2lVS3F3c2J4SGRuUmZsb2FadzBjZVRz?= =?utf-8?B?WGVGak1rZXBHN2VaM3hlTUp3Y1VKY2VmU3d2MXRvdkQzYXRMVjNQaEkyRjhm?= =?utf-8?B?dTV6Y09WYzZXcTkzdWVTbFpvaTJhaEM0bVNzMkhiRXFmcUFmMDAzeFg2bC9x?= =?utf-8?B?YVZ1Ty9tYWJUdHVHRE1uWkxNYkhmcnUxU1hUT3RGYjh2c1lKMkE1ai80TFVl?= =?utf-8?B?bngvMGpmV2lwMkkxNjhTbGc2dHpBM3l3aWxmUTR2THJqSW1ZQlJxM0h6SWRX?= =?utf-8?B?cnNwelhDSVJPcndpb05WSE9COWUxRStNT1NHcE91RFhaMXM0dFAvMmhwVUl6?= =?utf-8?B?OFQwaEhub3lxdk84NThGVXJpZWQrZEc3ZFBOV3Z5R1JBMGtVNlNHSkFwbXBs?= =?utf-8?Q?EbpPRVsyBlEZ9CpjCUMzvr4U1BLv1cOPqFl0tWywKm3L?= Content-Type: text/plain; charset="utf-8" Content-ID: <24123844DDD8134CB568B2C7E96CE3EA@EURP195.PROD.OUTLOOK.COM> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: ucll.be X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AM9P195MB0790.EURP195.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 1e749e0b-5ab1-4b83-4ecb-08db68f1e0fb X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Jun 2023 14:00:27.3945 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e638861b-15d9-4de6-a65d-b48789ae1f08 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: OP/KfOUkO5jcnyqiqGj6UTr5Sq1xuT+aQEa/XuyyCfaBff2wE4GRyToOjGVwQk1wd5skPZT2BlT1nk7wY6tHeQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1P195MB0703 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Sm9lIENvbndheSBzY2hyZWVmIG9wIHZyIDA5LTA2LTIwMjMgb20gMDk6MTYgWy0wNDAwXToNCj4g T24gNi84LzIzIDIyOjE3LCBQYXQgVHJhaW5vciB3cm90ZToNCj4gPiBJIG5lZWQgdG8gaGF2ZSBh IHZlcnkgbGFyZ2UgbWF0cml4IHRvIG1haW50YWluICYgcXVlcnksIGFuZCBpZiBub3QgDQo+ID4g KDEsNjAwIGNvbHVtbiBsaW1pdCksIHRoZW4gaG93IGNvdWxkIHN1Y2ggZGF0YSBiZSBicm9rZW4g ZG93biB0bw0KPiA+IHdvcms/DQo+IA0KPiDCoCAxMDAsMDAwIHJvd3MgKg0KPiDCoCAxMDAsMDAw IGNvbHVtbnMgKg0KPiDCoCA4IGJ5dGVzIChhc3N1bWluZyBmbG9hdDgpDQo+ID0gYWJvdXQgODAg R0IgcGVyIG1hdHJpeCBpZiBJIGdvdCB0aGUgbWF0aCBjb3JyZWN0Lg0KPiANCj4gDQoNCmJhc2Vk IG9uIG15IHBlcnNvbmFsIGV4cGVyaWVuY2UgaSB3b3VsZCBub3QgdXNlIHBvc3RncmVzIGluIHRo ZSBjYXNlDQp3aGVyZSB5b3UgbmVlZCBtYW55IGNvbHVtbnMsIHUgY2FuIHdvcmsgYXJvdW5kIHRo aXMgd2l0aCBqc29uIGZvcg0KZXhhbXBsZSwgYnV0IGl0IHdpbGwgbGlrZWx5IGVuZCB1cCBiZWlu ZyBsZXNzIGVhc3kgdG8gd29yayB3aXRoDQoNCmFzIEpvZSByZXBsaWVkOiBSIG9yIFB5dGhvbiBh cmUgcHJvYmFibHkgYSBiZXR0ZXIgZml0LA0Kb3IgYW5vdGhlciBkYXRhYmFzZSB0aGF0IGNhbiBl YXNpbHkgaGFuZGxlIGEgbG90IG9mIGNvbHVtbnMsDQpwb3N0Z3JlcyBpcyBhIGdyZWF0IGRhdGFi YXNlLCBidXQgbm90IHdoZW4geW91IG5lZWQgYSBsb3Qgb2YgY29sdW1ucw0KDQooYXMgeW91IG5v dGVkKzoNCnRoZXJlIG1pZ2h0IGJlIGFub3RoZXIgYmFja2VuZCBzdG9yYWdlIGZvciBwb3N0Z3Jl cyB0aGF0IGNhbiBoYW5kbGUNCnRoaXMgYmV0dGVyIChvciBpbiB0aGUgZnV0dXJlPyksIGJ1dCBp IGRvbid0IHRoaW5rIHRoZXJlIGlzIG9uZTsNCmFsc28gdGhlcmUgaXMgdGhlIGhlYWRlciBmb3Ig d2hpY2ggc3RhbmRhcmQgOEsgaXMgcHJvdmlzaW9uZWQgYW55d2F5LA0Kc28gdGhhdCBpcyB0aGUg Zmlyc3QgYm90dGxlbmVjayAoeW91IGNhbiBjaGFuZ2UgdGhpcyB2YWx1ZSwgaWYgeW91DQpjb21w aWxlIHBvc3RncmVzIHlvdXJzZWxmKQ0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy9j dXJyZW50L2xpbWl0cy5odG1sICkNCg0KV2ltDQoNCg0K