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 --+