Message DB: Event Store and Message Store for PostgreSQL

Re:Message DB: Event Store and Message Store for PostgreSQL by adverbly on Monday December 16, 2019 @11:24PM (#21810559)

Looks cool. I can't find any performance or benchmarks though. Anyone care to guess/ballpark what kind of write speeds single nodes might be able to handle?

[ Parent | on HN ]

Re:Message DB: Event Store and Message Store for PostgreSQL by sbellware on Tuesday December 17, 2019 @01:10PM (#21816567)

There are too many "it depends" issues, especially the hardware, and not least the application architecture sitting on top of it.

There's a script in the Message DB codebase that will do some fairly rudimentary read and write performance measures for your Postgres deployment:

https://github.com/message-db/message-db/blob/master/databas...

It's run right on the database, so no network I/O or client implementation in the loop - which is inevitably non-representative of "real world" scenarios.

[ Parent | on HN ]

Re:Message DB: Event Store and Message Store for PostgreSQL by GordonS on Tuesday December 17, 2019 @07:50AM (#21812960)

I got stuck looking for some perf figures too. I realise they are going to vary widely by hardware, batch size, message size etc, but it would be really useful to have a comparison against, for example, a single RabbitMQ instance.

[ Parent | on HN ]

Re:Message DB: Event Store and Message Store for PostgreSQL by sbellware on Tuesday December 17, 2019 @07:54PM (#21820749)

A message store is really not a comparable pattern to a message queue. It's unlikely that the usages would be similar enough to engender a meaningful comparison. They're not as dissimilar as an apples-to-oranges comparison, but maybe an apples-to-applesauce comparison.

[ Parent | on HN ]