Re:.NET Transactional Document DB and Event Store on PostgreSQL
by GordonS on Friday September 04, 2020 @04:19PM
(#24378504)
We're not running at scale, at least not the kind where performance of the library is likely to be an issue. We have around 50 tenants with a handful of users each. Tenants have up to 100's of millions of rows in Postgres - not exactly big data levels, but pretty big still.
I don't have perf numbers anymore, but I did some performance testing before I started using it a few years ago, and even back then it was much faster than EF/EFCore. The team have made many performance improvements since then. Considering the ease of use, and the fact you get NoSQL-style JSON documents that work alongside regular relational tables, basically the performance impact is as good as neglibible, IMO.
If you want to work with JSON documents, I highly recommend Marten.
It does have a Benchmarks project if you'd like to run some tests[0], and I'm sure the team would be happy to answer any questions over in Gitter[1].
[0] https://github.com/JasperFx/marten/blob/07d99ed80a1f0c436c4f...
Since you're using it, I'd like to know more about it's performance profile. Can't really find any performance/speed comparisons online. And what kind of scale are you running.
I'm right at the beginning of a project for a client and I'm roughing out the foundational code with pgsql already, so it would be a perfect time to take a look at it.
Thanks!