Edson Richter <edsonrichter@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
