On 8/26/19 7:49 PM, Peter Geoghegan wrote:
> Not surprising, since the TPC-E benchmark models a financial trading
> application.
> The good news there is that that will almost certainly be a lot better
> in Postgres 12. TPC-E also has a number of very low cardinality
> indexes, despite being an OLTP benchmark.
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?
--
Arcadiy Ivanov
arcadiy(at)gmail(dot)com | @arcivanov | https://ivanov.biz
https://github.com/arcivanov