Limit events by tag query ordering sizes

akka / akka-persistence-jdbc

Asynchronously writes journal and snapshot entries to configured JDBC databases so that Akka Actors can recover state

https://doc.akka.io/docs/akka-persistence-jdbc/

Other

309 stars 142 forks source link

Limit events by tag query ordering sizes #681

Closed johanandren closed 2 years ago

johanandren commented 2 years ago

This makes it possible to limit the chunks of the journal queried for events by tag to work around bad performance in some dbs when starting a new query/projection from 0 after a lot of tagged events was already persisted. By default the limiting is disabled, will need app specific tuning when enabled.

lightbend-cla-validator commented 2 years ago

Hi @JustinPihony,

Thank you for your contribution! We really value the time you've taken to put this together.

We see that you have signed the Lightbend Contributors License Agreement before, however, the CLA has changed since you last signed it. Please review the new CLA and sign it before we proceed with reviewing this pull request:

https://www.lightbend.com/contribute/cla

johanandren commented 2 years ago

Tested with a events-by-tag-buffer-sizes-per-query = 10, all tests green. I'll revert it to default as disabled now.