citext performance

2018-04-06 Thread Deepak Somaiya
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

[PERFORM] Dissuade the use of exclusion constraint index

2018-04-06 Thread Adam Brusselback
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