Search Postgresql Archives

Re: Behavior change in PostgreSQL 14Beta3 or bug?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux