Do BRIN indexes support MIN/MAX?

Поиск
Список
Период
Сортировка
От Andrey Klochkov
Тема Do BRIN indexes support MIN/MAX?
Дата
Msg-id CAFcR=R5jYvttbc5H0GUd7evczLsQecMUVFw-wv_QP0=aOTJixA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Do BRIN indexes support MIN/MAX?  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Using CTID system column as a "temporary" primary key
Следующее
От: Sebastien Flaesch
Дата:
Сообщение: Re: Using CTID system column as a "temporary" primary key