| From: | Vik Fearing <vik(at)2ndquadrant(dot)fr> |
|---|---|
| To: | Viswanath <M(dot)Viswanath16(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Text,Citext column and Btree index |
| Date: | 2016-09-01 07:57:37 |
| Message-ID: | b9b91ab6-5130-2e31-198c-1836654b3361@2ndquadrant.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emrul | 2016-09-01 09:13:58 | Array element foreign keys |
| Previous Message | Viswanath | 2016-09-01 07:34:56 | Text,Citext column and Btree index |