public inbox for [email protected]
help / color / mirror / Atom feedRe: pg_trgm upgrade to 1.6 led to load average increase
2+ messages / 2 participants
[nested] [flat]
* Re: pg_trgm upgrade to 1.6 led to load average increase
@ 2026-01-20 16:34 Adrian Klaver <[email protected]>
2026-01-21 08:38 ` Re: pg_trgm upgrade to 1.6 led to load average increase Nicolas Seinlet <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Adrian Klaver @ 2026-01-20 16:34 UTC (permalink / raw)
To: Nicolas Seinlet <[email protected]>; [email protected] <[email protected]>
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]
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_trgm upgrade to 1.6 led to load average increase
2026-01-20 16:34 Re: pg_trgm upgrade to 1.6 led to load average increase Adrian Klaver <[email protected]>
@ 2026-01-21 08:38 ` Nicolas Seinlet <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Nicolas Seinlet @ 2026-01-21 08:38 UTC (permalink / raw)
To: [email protected] <[email protected]>; Adrian Klaver <[email protected]>
On Tuesday, January 20th, 2026 at 17:34, Adrian Klaver <[email protected]> wrote:
>
>
> 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.
>
Hello,
here is the table definition:
Table "public.ir_model_data"
Column | Type | Collation | Nullable | Default
-------------+-----------------------------+-----------+----------+-------------------------------------------
id | integer | | not null | nextval('ir_model_data_id_seq'::regclass)
create_uid | integer | | |
create_date | timestamp without time zone | | | timezone('UTC'::text, now())
write_date | timestamp without time zone | | | timezone('UTC'::text, now())
write_uid | integer | | |
noupdate | boolean | | | false
name | character varying | | not null |
module | character varying | | not null |
model | character varying | | not null |
res_id | integer | | |
Indexes:
"ir_model_data_pkey" PRIMARY KEY, btree (id)
"ir_model_data_create_uid_idx" btree (create_uid) WHERE create_uid IS NOT NULL AND (create_uid <> ALL (ARRAY[1, 208196]))
"ir_model_data_model_name_multilang_index" btree (name) WHERE model::text = ANY (ARRAY['account.account'::character varying::text, 'account.group'::character varying::text, 'account.tax'::character varying::text, 'account.fiscal.position'::character varying::text])
"ir_model_data_model_res_id_index" btree (model, res_id)
"ir_model_data_module_name_uniq_index" UNIQUE, btree (module, name)
"ir_model_data_name_idx2" gist (name gist_trgm_ops)
"ir_model_data_write_uid_idx" btree (write_uid) WHERE write_uid IS NOT NULL AND (write_uid <> ALL (ARRAY[1, 208196]))
Check constraints:
"ir_model_data_name_nospaces" CHECK (name::text !~~ '% %'::text)
> > Thanks in advance,
> >
> > Nicolas
>
>
>
> --
> Adrian Klaver
> [email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-01-21 08:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-01-20 16:34 Re: pg_trgm upgrade to 1.6 led to load average increase Adrian Klaver <[email protected]>
2026-01-21 08:38 ` Nicolas Seinlet <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox