Search Postgresql Archives

Do BRIN indexes support MIN/MAX?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux