I went overboard on CITEXT columns on a particularly large table in my application. I would like to back some of these out as it's confusing how to trigger lookups on the desired indexes.
My question is, can I do this without encountering any major difficulties? And if I change this, do I need to rebuild any indexes on those fields?
Will there be any space gains from moving in this direction?
Case-insensitive queries are not necessary on these columns.
I have counts against this table that are predicated on 2 columns, and these counts are taking over an hour. The table has 60 columns.
I am using Postgres 10.6.
I'm primarily interested in whether indexes need to be rebuilt if they contain a column that has changed from CITEXT to VARCHAR.