On Mon, Aug 26, 2019 at 4:59 PM Arcadiy Ivanov <arca...@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
