Hello - I have started to make much more use of BRIN indexes on timestamp fields on tables which are insert-only. I have seen great performance with these and of course far less overhead.
However, I am noticing that a simple aggregate is not using the index. I don't find anything obvious in the docs as to why, and I am not sure if the operator is not actually supported, or for some reason it is not choosing it because of the estimate. I have a very large table with 4 billion rows and a BRIN index on timestamp spanning from 2013 to present. I am running this simple query: SELECT MIN(created_at) FROM table; It is choosing a parallel seq scan as opposed to a BRIN bitmap scan. Please note also that the following queries that I am using are using the index with great performance: SELECT * FROM table WHERE created_at > '2013-04-01' AND created_at <= '2013-04-08'; I can provide more info. But first - am I missing something obvious? Thanks, Jeremy
