diff options
| author | Álvaro Herrera <alvherre@kurilemu.de> | 2025-11-04 13:23:26 +0100 |
|---|---|---|
| committer | Álvaro Herrera <alvherre@kurilemu.de> | 2025-11-04 13:23:26 +0100 |
| commit | a95e3d84c0e0ffd1e27c185dd69d053e43f2f8b5 (patch) | |
| tree | c988ff90ff39e46bd4df1db0834b3707d343bb66 /src/backend/utils/adt/regexp.c | |
| parent | c09a06918dff9a1651ed12a24eb03712331b234b (diff) | |
BRIN autosummarization may need a snapshot
It's possible to define BRIN indexes on functions that require a
snapshot to run, but the autosummarization feature introduced by commit
7526e10224f0 fails to provide one. This causes autovacuum to leave a
BRIN placeholder tuple behind after a failed work-item execution, making
such indexes less efficient. Repair by obtaining a snapshot prior to
running the task, and add a test to verify this behavior.
Author: Álvaro Herrera <alvherre@kurilemu.de>
Reported-by: Giovanni Fabris <giovanni.fabris@icon.it>
Reported-by: Arthur Nascimento <tureba@gmail.com>
Backpatch-through: 13
Discussion: https://postgr.es/m/202511031106.h4fwyuyui6fz@alvherre.pgsql
Diffstat (limited to 'src/backend/utils/adt/regexp.c')
0 files changed, 0 insertions, 0 deletions