Do BRIN indexes support MIN/MAX? - Mailing list pgsql-general

From Andrey Klochkov
Subject Do BRIN indexes support MIN/MAX?
Date
Msg-id CAFcR=R5jYvttbc5H0GUd7evczLsQecMUVFw-wv_QP0=aOTJixA@mail.gmail.com
Whole thread Raw
Responses Re: Do BRIN indexes support MIN/MAX?  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
List 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

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Using CTID system column as a "temporary" primary key
Next
From: Sebastien Flaesch
Date:
Subject: Re: Using CTID system column as a "temporary" primary key