Add major near-zero downtime upgrades of PostgreSQL

[hors]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Tell us about the feature
I want to be able to perform near-zero-downtime major upgrades to PostgreSQL. Like from PG18 to PG19.

Which product(s) is this request for?
Operators PostgreSQL

Tell us about the problem
During the major update, we may encounter a reindexing issue, which could cause significant downtime for our database service.