Petra

Also worth checking constraints that depend on text ordering, not only the obvious indexes.

Did this on a database large enough that it mattered, so the practical warning: rebuilding text indexes is not a quick operation and the plain version takes write locks.

Plan it as maintenance rather than fitting it in. There is a concurrent variant that avoids the locking and takes considerably longer, and picking it at 3am because you did not check first is how a one hour job becomes an outage.