On Tue, Mar 17, 2020 at 9:25 PM Michael Paquier <michael@paquier.xyz> wrote:
There is no way to know how much indexes would get broken without having a look at it. Anything ASCII-based should be of no problem. If you have a doubt, reindexing evey index which includes text column data is the best course of action in my opinion if you have any doubts, because that's safe even if it has a higher cost.
Here's the fun part. A lot of the tables use UUIDv4 strings for primary keys. However these are stored in text/varchar columns.