public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Nicolas Seinlet <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: pg_trgm upgrade to 1.6 led to load average increase
Date: Tue, 20 Jan 2026 08:34:17 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <F-DrgibQiu1I_ItlkIz765ee1SJJvVg187PNonwprn0eT7GC56_kJcU8CkP8Y10bs4-TT6n_JJ3fFPP4H3xPtJLc5W5bE9AATi99VWaKbYc=@seinlet.com>
References: <F-DrgibQiu1I_ItlkIz765ee1SJJvVg187PNonwprn0eT7GC56_kJcU8CkP8Y10bs4-TT6n_JJ3fFPP4H3xPtJLc5W5bE9AATi99VWaKbYc=@seinlet.com>
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]
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: pg_trgm upgrade to 1.6 led to load average increase
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox