Postgres Pro
Downloads
Home   >   mailing lists

Re: Behavior change in PostgreSQL 14Beta3 or bug? - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: Behavior change in PostgreSQL 14Beta3 or bug?
Date
Msg-id CAH2-WzkNuMkFns4cYfqZq0BZXNpxh=FOS2ue4-9Cus=kB8DfSA@mail.gmail.com
Whole thread Raw
In response to Behavior change in PostgreSQL 14Beta3 or bug?  ("Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>)
Responses Re: Behavior change in PostgreSQL 14Beta3 or bug?
Re: Behavior change in PostgreSQL 14Beta3 or bug?
List pgsql-general
Tree view
It's a non-hot update, and so there is a single dead index tuple. You're seeing the new optimization that makes vacuum skip indexes in marginal cases. 

Try running vacuum with index cleanup = on. 

Peter Geoghegan
(Sent from my phone)

pgsql-general by date:

Previous
From: "Daniel Westermann (DWE)"
Date:
Subject: Behavior change in PostgreSQL 14Beta3 or bug?
Next
From: "Daniel Westermann (DWE)"
Date:
Subject: Re: Behavior change in PostgreSQL 14Beta3 or bug?