Re: [PERFORM] Performance problems with postgres and null Values?

2016-04-22 Thread Merlin Moncure
On Thu, Apr 21, 2016 at 4:49 AM, Sven Kerkling wrote: > Can somebody help me with these performance Problem. > > What can I try to solve this? can you explain what the problem actually is? Which query is running slow and how fast do you think it should run? merlin -- Sent via pgsql-performan

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

2016-04-22 Thread Rob Imig
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 behavior I need would require a huge amount of OR conditions (