Folks, I read following (PostgreSQL: Documentation: 9.6: citext) and it does
not hold true in my testing.. i.e citext is not performing better than lower.Am
I missing something? help is appreciated.
|
|
|
| | |
|
|
|
| |
PostgreSQL: Documentation: 9.6: citext
|
|
|
"citext
Hey all,
I'm using Postgres 10.3
6 core VM with 16gb of ram
My database schema requires a good bit of temporal data stored in a
few my tables, and I make use of ranges and exclusion constraints to
keep my data consistent.
I have quite a few queries in my DB which are using a very sub-optimal
inde