Vitesse Data: Postgres + LLVM

Re:Vitesse Data: Postgres + LLVM by BenoitP on Friday October 17, 2014 @01:44PM (#8472252)

I saw an instance of your talk at another venue. At the time I was learning about bitmap indexes (because we needed OLAP capabilities on a another database engine that is not postgres). Your talk reminded me furiously of them, but in the end I was not able to further investigate the difference.

How does your technology differ from bitmap indexes? Have you solved the performance problem of updating random rows, for example?

[ Parent | on HN ]

Re:Vitesse Data: Postgres + LLVM by cbsmith on Saturday October 18, 2014 @01:40PM (#8475822)

Combining OLAP without OLTP (large aggregate queries + lots of real time updates) is the holy grail that Cassandra, for example, has addressed rather nicely.

Compressed bitmap indexes are awesome. Like most indexes, the updating random rows problem is best addressed using a log structured merge tree and amortizing your index updates. Just have an in-memory buffer of recently updated rows.

If you are doing mostly sums & counts type work and can deal with some level of inaccuracy, you can consider HyperLogLog...

[ Parent | on HN ]

Re:Vitesse Data: Postgres + LLVM by vtuulos on Friday October 17, 2014 @02:10PM (#8472438)

Our DeliRoll is used for analytics. It doesn't support random updates, it is append-only.

We use bitmap indexes in a number of places internally.

[ Parent | on HN ]