On 1/20/26 00:50, Nicolas Seinlet wrote:
Hello,
we've upgraded the pg_trgm extension from 1.0 to 1.6 on our production
database, while sticking our postgresql cluster version to 16. This led
to an increase in the load average of the server (twice the load average
on our use case). After investigation, we found our issue was linked to :
https://github.com/postgres/postgres/
commit/935f6666502250abde8615bc7805a6e5aa05a066 <https://github.com/
postgres/postgres/commit/935f6666502250abde8615bc7805a6e5aa05a066>
We issue queries like :
SELECT model, res_id FROM ir_model_data WHERE module='base' AND
name='public_user';
You need to provide the table definition, including indexes.
Thanks in advance,
Nicolas
--
Adrian Klaver
[email protected]
