Re: Very expensive update to update a single row

2025-09-23 Thread Sean M
Hi, My first thought is pending list costs associated with the GIN indexes. https://pganalyze.com/blog/gin-index You may be able to use pageinspect's function gin_metapage_info to see what the https://www.postgresql.org/docs/16/pageinspect.html#PAGEINSPECT-GIN-FUNCS https://gitlab.com/gitlab-com/

Very expensive update to update a single row

2025-09-23 Thread Dirschel, Steve
Postgres RDS running in AWS. PostgreSQL 16.8 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-17), 64-bit Table definition Table: request Column |Type | Collation | Nullable | Default --+

Re: Indexes on expressions with multiple columns and operators

2025-09-23 Thread Andrei Lepikhov
On 23/9/2025 12:20, Frédéric Yhuel wrote: On 9/22/25 23:15, Andrei Lepikhov wrote: It may solve at least one issue with the 'dependencies' statistics: a single number describing the dependency between any two values in the columns often leads to incorrect estimations, as I see. For what it's