Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vi7Rh-00FUXE-2L for pgsql-general@arkaria.postgresql.org; Tue, 20 Jan 2026 08:50:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vi7Rg-00H6ZU-2w for pgsql-general@arkaria.postgresql.org; Tue, 20 Jan 2026 08:50:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vi7Rg-00H6ZM-0V for pgsql-general@lists.postgresql.org; Tue, 20 Jan 2026 08:50:40 +0000 Received: from mail-244117.protonmail.ch ([109.224.244.117]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vi7Rd-001UHR-22 for pgsql-general@lists.postgresql.org; Tue, 20 Jan 2026 08:50:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=seinlet.com; s=protonmail3; t=1768899035; x=1769158235; bh=IIg1Z5PvPJXdiHGtM5E02DvFKnhObeXALV+U6ZeKrDA=; h=Date:To:From:Subject:Message-ID:Feedback-ID:From:To:Cc:Date: Subject:Reply-To:Feedback-ID:Message-ID:BIMI-Selector; b=E/uWOuLmZumly4Xa/q4bODBzvgS6S6r7ER0pxqQwaGlDgH5teOrbkRHIZ1WymaMm5 1QAhKV+HhN7uSIbev4n8/J84lPeJBuIgWrq48b3GBaiuVw4k5Vay+VYs+1/B3xmO82 Q9dhwhJMCmDbBO5gU6zxz7s/78YyKSmKLoOk6M4vYggMasp21b8E3fjD4r0Eof24m9 YakLC4KksgWL3/N8FpKkOE5MEGl1J5myBk0Wz93bqL2frLYjXLdvYZyRZR5KZ1sjbJ yOjG0509aa9bHqAk/T6MEwlsEi59WGxvXzxkDCE0X6/UvXmjhP1XE5N+l9DqMHk83Q N0YhkO4HIkbWA== Date: Tue, 20 Jan 2026 08:50:33 +0000 To: "pgsql-general@lists.postgresql.org" From: Nicolas Seinlet Subject: pg_trgm upgrade to 1.6 led to load average increase Message-ID: Feedback-ID: 32582315:user:proton X-Pm-Message-ID: 40d6c748d1b9e9ac2e03bf5394e3726b07742159 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="b1=_nrx5Jz2IklJWv4bWpJ2x5dhBQMlM1IP9YMdD1B0tN8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --b1=_nrx5Jz2IklJWv4bWpJ2x5dhBQMlM1IP9YMdD1B0tN8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 SGVsbG8sCgp3ZSd2ZSB1cGdyYWRlZCB0aGUgcGdfdHJnbSBleHRlbnNpb24gZnJvbSAxLjAgdG8g MS42IG9uIG91ciBwcm9kdWN0aW9uIGRhdGFiYXNlLCB3aGlsZSBzdGlja2luZyBvdXIgcG9zdGdy ZXNxbCBjbHVzdGVyIHZlcnNpb24gdG8gMTYuIFRoaXMgbGVkIHRvIGFuIGluY3JlYXNlIGluIHRo ZSBsb2FkIGF2ZXJhZ2Ugb2YgdGhlIHNlcnZlciAodHdpY2UgdGhlIGxvYWQgYXZlcmFnZSBvbiBv dXIgdXNlIGNhc2UpLiBBZnRlciBpbnZlc3RpZ2F0aW9uLCB3ZSBmb3VuZCBvdXIgaXNzdWUgd2Fz IGxpbmtlZCB0byA6Cmh0dHBzOi8vZ2l0aHViLmNvbS9wb3N0Z3Jlcy9wb3N0Z3Jlcy9jb21taXQv OTM1ZjY2NjY1MDIyNTBhYmRlODYxNWJjNzgwNWE2ZTVhYTA1YTA2NgoKV2UgaXNzdWUgcXVlcmll cyBsaWtlIDoKU0VMRUNUIG1vZGVsLCByZXNfaWQgRlJPTSBpcl9tb2RlbF9kYXRhIFdIRVJFIG1v ZHVsZT0nYmFzZScgQU5EIG5hbWU9J3B1YmxpY191c2VyJzsKCldpdGggMS4wIGV4dGVuc2lvbiwg dGhlIHF1ZXJ5IGlzIHBsYW5uZWQgd2l0aCBhIG1hdGNoaW5nIGJ0cmVlIGluZGV4OgoiaXJfbW9k ZWxfZGF0YV9tb2R1bGVfbmFtZV91bmlxX2luZGV4IiBVTklRVUUsIGJ0cmVlIChtb2R1bGUsIG5h bWUpCgpXaXRoIDEuNiBleHRlbnNpb24sIHRoZSBxdWVyeSBpcyBwbGFubmVkIHdpdGggYSBnaXN0 IGluZGV4OgoiaXJfbW9kZWxfZGF0YV9uYW1lX2lkeDIiIGdpc3QgKG5hbWUgZ2lzdF90cmdtX29w cykKCjEuMCBleHRlbnNpb24gZXhlY3V0ZXMgdGhlIHF1ZXJ5IGluIDAuMW1zLCB3aGlsZSAxLjYg aW4gMTAwbXMKCk91ciBzb2x1dGlvbiB3YXMgdG8gcmV2ZXJ0IHRvIHBnX3RyZ20gMS41LCBzbyBy ZW1vdmUgb3BlcmF0aW9uIDExIGZyb20gZ2lzdF90cmdtX29wcy4gQWZ0ZXIgdGhlIHJlbW92YWws IHRoZSBsb2FkIGF2ZXJhZ2Ugd2FzIGJhY2sgdG8gbm9ybWFsLgoKSXMgdGhlcmUgYW5vdGhlciB3 YXkgb2YgcHJldmVudGluZyBQb3N0Z3JlU1FMIHRvIHVzZSB0aGUgZ2lzdCBpbmRleCB3aGVuIGEg YnRyZWUgZXhhY3RseSBtYXRjaCB0aGUgY29uZGl0aW9uPyBJcyBpdCB2aWFibGUgdG8gc3RpY2sg d2l0aCB0aGUgZXh0ZW5zaW9uIGluIDEuNiwgYnV0IHdpdGggdGhlIG9wZXJhdGlvbiAxMSByZW1v dmVkIGZyb20gZ2lzdF90cmdtX29wcz8KUG9zdGdyZVNRTCAxNiBjb250YWlucyBodHRwczovL2dp dGh1Yi5jb20vcG9zdGdyZXMvcG9zdGdyZXMvY29tbWl0L2NkOTQ3OWFmMmFmMjVkN2ZhOWJmZDI0 ZGQ0ZGNmOTc2YjM2MGYwNzcgLCBidXQgaXMgdGhpcyBhcHBsaWNhYmxlIHRvIGdpc3Q/CgpUaGFu a3MgaW4gYWR2YW5jZSwKCk5pY29sYXM= --b1=_nrx5Jz2IklJWv4bWpJ2x5dhBQMlM1IP9YMdD1B0tN8 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6IEFyaWFsLCBzYW5zLXNlcmlmOyBmb250LXNpemU6IDE0 cHg7Ij5IZWxsbyw8L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTogQXJpYWwsIHNhbnMtc2Vy aWY7IGZvbnQtc2l6ZTogMTRweDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTog QXJpYWwsIHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogMTRweDsiPndlJ3ZlIHVwZ3JhZGVkIHRoZSBw Z190cmdtIGV4dGVuc2lvbiBmcm9tIDEuMCB0byAxLjYgb24gb3VyIHByb2R1Y3Rpb24gZGF0YWJh c2UsIHdoaWxlIHN0aWNraW5nIG91ciBwb3N0Z3Jlc3FsIGNsdXN0ZXIgdmVyc2lvbiB0byAxNi4g VGhpcyBsZWQgdG8gYW4gaW5jcmVhc2UgaW4gdGhlIGxvYWQgYXZlcmFnZSBvZiB0aGUgc2VydmVy ICh0d2ljZSB0aGUgbG9hZCBhdmVyYWdlIG9uIG91ciB1c2UgY2FzZSkuIEFmdGVyIGludmVzdGln YXRpb24sIHdlIGZvdW5kIG91ciBpc3N1ZSB3YXMgbGlua2VkIHRvIDo8YnI+PHNwYW4+PGEgdGFy Z2V0PSJfYmxhbmsiIHJlbD0ibm9yZWZlcnJlciBub2ZvbGxvdyBub29wZW5lciIgaHJlZj0iaHR0 cHM6Ly9naXRodWIuY29tL3Bvc3RncmVzL3Bvc3RncmVzL2NvbW1pdC85MzVmNjY2NjUwMjI1MGFi ZGU4NjE1YmM3ODA1YTZlNWFhMDVhMDY2Ij5odHRwczovL2dpdGh1Yi5jb20vcG9zdGdyZXMvcG9z dGdyZXMvY29tbWl0LzkzNWY2NjY2NTAyMjUwYWJkZTg2MTViYzc4MDVhNmU1YWEwNWEwNjY8L2E+ PC9zcGFuPjxicj48YnI+V2UgaXNzdWUgcXVlcmllcyBsaWtlIDo8YnI+PHNwYW4+U0VMRUNUIG1v ZGVsLCByZXNfaWQgRlJPTSBpcl9tb2RlbF9kYXRhIFdIRVJFIG1vZHVsZT0nYmFzZScgQU5EIG5h bWU9J3B1YmxpY191c2VyJzs8L3NwYW4+PGJyPjxicj5XaXRoIDEuMCBleHRlbnNpb24sIHRoZSBx dWVyeSBpcyBwbGFubmVkIHdpdGggYSBtYXRjaGluZyBidHJlZSBpbmRleDo8YnI+PHNwYW4+Imly X21vZGVsX2RhdGFfbW9kdWxlX25hbWVfdW5pcV9pbmRleCIgVU5JUVVFLCBidHJlZSAobW9kdWxl LCBuYW1lKTwvc3Bhbj48YnI+PGJyPldpdGggMS42IGV4dGVuc2lvbiwgdGhlIHF1ZXJ5IGlzIHBs YW5uZWQgd2l0aCBhIGdpc3QgaW5kZXg6PGJyPjxzcGFuPiJpcl9tb2RlbF9kYXRhX25hbWVfaWR4 MiIgZ2lzdCAobmFtZSBnaXN0X3RyZ21fb3BzKTwvc3Bhbj48YnI+PGJyPjEuMCBleHRlbnNpb24g ZXhlY3V0ZXMgdGhlIHF1ZXJ5IGluIDAuMW1zLCB3aGlsZSAxLjYgaW4gMTAwbXM8YnI+PGJyPk91 ciBzb2x1dGlvbiB3YXMgdG8gcmV2ZXJ0IHRvIHBnX3RyZ20gMS41LCBzbyByZW1vdmUgb3BlcmF0 aW9uIDExIGZyb20mbmJzcDs8Y29kZT5naXN0X3RyZ21fb3BzPC9jb2RlPi4gQWZ0ZXIgdGhlIHJl bW92YWwsIHRoZSBsb2FkIGF2ZXJhZ2Ugd2FzIGJhY2sgdG8gbm9ybWFsLiZuYnNwOzwvZGl2Pjxk aXYgc3R5bGU9ImZvbnQtZmFtaWx5OiBBcmlhbCwgc2Fucy1zZXJpZjsgZm9udC1zaXplOiAxNHB4 OyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OiBBcmlhbCwgc2Fucy1zZXJpZjsg Zm9udC1zaXplOiAxNHB4OyI+SXMgdGhlcmUgYW5vdGhlciB3YXkgb2YgcHJldmVudGluZyBQb3N0 Z3JlU1FMIHRvIHVzZSB0aGUgZ2lzdCBpbmRleCB3aGVuIGEgYnRyZWUgZXhhY3RseSBtYXRjaCB0 aGUgY29uZGl0aW9uPyBJcyBpdCB2aWFibGUgdG8gc3RpY2sgd2l0aCB0aGUgZXh0ZW5zaW9uIGlu IDEuNiwgYnV0IHdpdGggdGhlIG9wZXJhdGlvbiAxMSZuYnNwO3JlbW92ZWQgZnJvbSA8Y29kZT5n aXN0X3RyZ21fb3BzPC9jb2RlPj88YnI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5 OiBBcmlhbCwgc2Fucy1zZXJpZjsgZm9udC1zaXplOiAxNHB4OyI+UG9zdGdyZVNRTCAxNiBjb250 YWlucyZuYnNwOzxzcGFuPjxhIHRhcmdldD0iX2JsYW5rIiByZWw9Im5vcmVmZXJyZXIgbm9mb2xs b3cgbm9vcGVuZXIiIGhyZWY9Imh0dHBzOi8vZ2l0aHViLmNvbS9wb3N0Z3Jlcy9wb3N0Z3Jlcy9j b21taXQvY2Q5NDc5YWYyYWYyNWQ3ZmE5YmZkMjRkZDRkY2Y5NzZiMzYwZjA3NyI+aHR0cHM6Ly9n aXRodWIuY29tL3Bvc3RncmVzL3Bvc3RncmVzL2NvbW1pdC9jZDk0NzlhZjJhZjI1ZDdmYTliZmQy NGRkNGRjZjk3NmIzNjBmMDc3PC9hPjwvc3Bhbj4mbmJzcDssIGJ1dCBpcyB0aGlzIGFwcGxpY2Fi bGUgdG8gZ2lzdD88L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTogQXJpYWwsIHNhbnMtc2Vy aWY7IGZvbnQtc2l6ZTogMTRweDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTog QXJpYWwsIHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogMTRweDsiPlRoYW5rcyBpbiBhZHZhbmNlLDwv ZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OiBBcmlhbCwgc2Fucy1zZXJpZjsgZm9udC1zaXpl OiAxNHB4OyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OiBBcmlhbCwgc2Fucy1z ZXJpZjsgZm9udC1zaXplOiAxNHB4OyI+Tmljb2xhczxicj48YnI+PGJyPjwvZGl2Pg0KPGRpdiBz dHlsZT0iZm9udC1mYW1pbHk6IEFyaWFsLCBzYW5zLXNlcmlmOyBmb250LXNpemU6IDE0cHg7IiBj bGFzcz0icHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2sgcHJvdG9ubWFpbF9zaWduYXR1cmVfYmxv Y2stZW1wdHkiPg0KICAgIDxkaXYgY2xhc3M9InByb3Rvbm1haWxfc2lnbmF0dXJlX2Jsb2NrLXVz ZXIgcHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2stZW1wdHkiPjwvZGl2Pg0KICAgIA0KICAgICAg ICAgICAgPGRpdiBjbGFzcz0icHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2stcHJvdG9uIHByb3Rv bm1haWxfc2lnbmF0dXJlX2Jsb2NrLWVtcHR5Ij4NCiAgICAgICAgDQogICAgICAgICAgICA8L2Rp dj4NCjwvZGl2Pg0K --b1=_nrx5Jz2IklJWv4bWpJ2x5dhBQMlM1IP9YMdD1B0tN8--