On 09/01/2016 09:34 AM, Viswanath wrote: > Hi, > Why is a citext column not using Btree index for like operation even without > any wildcard character?
Because it doesn't know how. > It can use Btree index if there is no wildcard character and if it is at the > end right? No; use pg_trgm for this. > Also a text column is using index when there is no wildcard character,but it > is also not using if it is present at the end. Did you declare your index with text_pattern_ops? -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
