I'm new to bloom indexes and currently my table has 3 partial indexes for the same column in the
WHERE clause and with different column combinations for the same table. I was trying to replace them all with 1 bloom index.
However, when I create a bloom index with
WHERE clause using below syntax, I get below error:
CREATE EXTENSION bloom; CREATE INDEX idx_bloom_bar ON message USING bloom (s, p, c, m, e, id) WHERE (islatest = true) WITH (length=56, col1=4, col2=4, col3=4, col4=4, col5=4, col6=4);
SQL Error : ERROR: syntax error at or near "WITH" Position: 165
WHERE clause, I'm able to create this index successfully.
Please let me know if we can use them as a replacement of multiple partial indexes or not to reduce number of indexes on my table.