On 3 October 2016 at 10:58, Ivan Voras <ivoras@gmail.com> wrote:
> I get that, my question was more about why the index scan returned 25 mil
> rows, when the pages are sequentially filled by timestamps? In my
> understading of BRIN, it should have returned a small number of pages which
> would have been filtered (and sorted) for the exact data, right?
That could be most simply explained if the distribution of your data
is not what you think it is.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services