- What is happening with each operator class, and why is it necessary to use text_pattern_ops when using utf-8?
- When using the default operator class with C, what happens to the text column indexes if the database is dumped to another Postgres that uses utf-8? Is it simply a matter of creating new indexes with
- Does the default operator class with C perform any better or worse than text_pattern_ops?
I'm considering changing the RDS
client_encoding parameter to
C so it wouldn't be necessary to use
text_pattern_ops everywhere, but I'd like to find out if any disadvantages (other than not supporting emojis and other languages) or complications may exist.