Do BRIN indexes support MIN/MAX?

Andrey Klochkov <diggerk@gmail.com>

From: Andrey Klochkov <diggerk@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2023-03-29T17:18:31Z
Lists: pgsql-general
Hello,
We've started experimenting with using BRIN indexes for some of our large
tables, as a replacement for B-Tree on "natural" timestamp columns that
seem to be a good case for BRIN. Is it correct that BRIN indexes don't
support MIN/MAX operations ?

We see that a query like `SELECT max(timestamp_column) FROM table` does a
sequential scan on the table instead of using the index.

We're on Postgres 10.23 at the moment if that's important.

-- 
Andrey Klochkov