Re: [PERFORM] Performant queries on table with many boolean columns

2016-04-22 Thread Rob Imig
11'::"bit") = B'1'::"bit") Rows Removed by Filter: 1191 Total runtime: 9359.593 ms (4 rows) *Time: 9360.072 ms* On Thu, Apr 21, 2016 at 3:34 PM, Rob Imig wro

Re: [PERFORM] Performant queries on table with many boolean columns

2016-04-21 Thread Rob Imig
Hey all, Lots of interesting suggestions! I'm loving it. Just came back to this a bit earlier today and made a sample table to see what non-index performance would be. Constructed data just like above (used 12M rows and 80% true for all 100 boolean columns) Here's an analyze for what I'd expect

[PERFORM] Performant queries on table with many boolean columns

2016-04-20 Thread Rob Imig
Hey all, New to the lists so please let me know if this isn't the right place for this question. I am trying to understand how to structure a table to allow for optimal performance on retrieval. The data will not change frequently so you can basically think of it as static and only concerned abou