Does posgres support case insensitive collation on standard varcharrs? Last time I used it that was not an option so it made everything a lot more complicated.

Does posgres support case insensitive collation on standard varcharrs? Last time I used it that was not an option so it made everything a lot more complicated. Postgrges also did not support hints for queries so tweaking performance was more complicated. Both MySQL and postgres performed much worse with complex queries than MSSQL even after tweaking.