min()/max() with BRIN indexes

Поиск
Список
Период
Сортировка
От Wayne
Тема min()/max() with BRIN indexes
Дата
Msg-id 20200229165024.GD20190@ln-1.useunix.net
обсуждение исходный текст
Ответы Re: min()/max() with BRIN indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
I have rather large tables that use a time stamp as an index. New entries
are continuously added to the table with the current time. If I convert
from BTREE to BRIN indexes and select records with specific date ranges
the BRIN is used and performance is acceptable. However I often want to
get the latest time stamp using the max() function. I didn't expect that
this would result in a sequential scan of the table and skip the BRIN
index.

Is this expected behavior?

Thanks,
Wayne



В списке pgsql-sql по дате отправления:

Предыдущее
От: Steve Midgley
Дата:
Сообщение: Re: Documentation of the pg_service file
Следующее
От: Tom Lane
Дата:
Сообщение: Re: min()/max() with BRIN indexes