On Mon, Aug 26, 2019 at 4:59 PM Arcadiy Ivanov <arcadiy@gmail.com> wrote:
> But apart from TPC-E and having to perform to it, is there any practical
> real world usefulness in trying to have a B-tree index on TS-based data
> just to have a PK on it, as opposed to having a BRIN on a TS field and
> calling it a day?
The index in question isn't an index on a timestamp. Its leading
column is an integer that is almost monotonically increasing, but not
quite.
If a BRIN index works for you, then that's probably what you should
use. I don't think that that's relevant, though. BRIN indexes have
clear disadvantages, including the fact that you have to know that
your data is amenable to BRIN indexing in order to use a BRIN index.
--
Peter Geoghegan