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 arca...@gmail.com | @arcivanov | https://ivanov.biz https://github.com/arcivanov
