rihad wrote:
> Btw, can we wrap the update of datcollate &datctype and rebuilding of
> textual indices inside a transaction with effectively 0 downtime?
No. Building indexes takes time and will lock the tables
until the transaction is done.
Yours,
Laurenz Albe