Edson Richter <edsonrichter(at)hotmail(dot)com> writes:
> I see. So, what is the overhead of having text_ops in opclass?
> Can I define it as default for all my indexes when textual type of any kind?
Why are you intent on defining anything? IMO, best practice is to let
the database choose the opclass, unless you have a very good and
specific reason to choose a non-default one for a particular index.
Letting it default is way more future-proof than specifying something.
regards, tom lane