What is the best way to be store, query & index a column containing around 100k bits?
I am attempting to do it creating a table like so:
CREATE TABLE public.search_bf ( id serial, bf integer ARRAY ) WITH ( OIDS = FALSE );
bf would have 3125 32bit integers which would give me the neccessary bits. I'm now trying to find a way of indexing and querying this.
I would like to use intarray but this doesn't work for bits.
I could use intarray if I just created a column
integer ARRAY but this would be really inefficent in terms of storage.