Query plan for the md5() index test:
Index Scan using lots_of_columns_md5_idx on lots_of_columns
(cost=0.93..3.94 rows=1 width=208) (actual time=0.043..0.043 rows=1 loops=1)
Index Cond: ('1ba23a0668ec17e230d98c270d6664dc'::text =
md5(
On Fri, Apr 22, 2016 at 6:57 AM, Rob Imig wrote:
> Just to followup where I'm at, I've constructed a new column which is a
> 100 bit bitstring representing all the flags. Created a b-tree index on
> that column and can now do super fast lookups (2) for specific scenarios
> however getting the beh
