Re: Do BRIN indexes support MIN/MAX?

2023-03-30 Thread Andrey Klochkov
ws), so it would be nice > to hear on the use cases for having min/max am scans or for having BRIN > ordered scans. > > Vladimir > > -- > Vladimir > -- Andrey Klochkov

Re: Do BRIN indexes support MIN/MAX?

2023-03-29 Thread Andrey Klochkov
s per page your index read drops > to about 10Mb, plus the 1Mb range. > > Also, I suspect you will have to read all unsummarized ranges ( > probably before the summarized ones, as unsummarized can discard > summarizeds, but not the other way ). > > Francisco Olarte. > -- Andrey Klochkov

Do BRIN indexes support MIN/MAX?

2023-03-29 Thread Andrey Klochkov
ery 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