Skip to content

`devshards` Optimizations for v0.2.13 db usage #1167

Closed @akup opened 2026-05-14 15:47 UTC 1 comment Updated 2026-07-20 04:54 UTC

During review of https://github.com/gonka-ai/gonka/pull/1143 there was found optimization points for db usage:

  1. Do not lock around createSession (https://github.com/gonka-ai/gonka/pull/1143#discussion_r3200794751)

  2. Add migration point to remove CREATE TABLE IF NOT EXIST from hot paths (https://github.com/gonka-ai/gonka/pull/1143#discussion_r3200930890, https://github.com/gonka-ai/gonka/pull/1143#discussion_r3205286743)

  3. Neat like this: https://github.com/gonka-ai/gonka/pull/1143#discussion_r3201178940, https://github.com/gonka-ai/gonka/pull/1143#discussion_r3205419993

  4. Optimize pruning (do not call every 30 seconds): https://github.com/gonka-ai/gonka/pull/1143#discussion_r3212576442

  5. Do not create SQLite base for each session when Postgres is available (https://github.com/gonka-ai/gonka/pull/1143#discussion_r3205241993)

  6. Snapshots in protobuf instead of json (https://github.com/gonka-ai/gonka/pull/1143#discussion_r3202629755)

It could be added in one PR for devshard realease. Should be merged with https://github.com/gonka-ai/gonka/pull/1162

💬 Comments (1)

@a-kuprin commented 2026-07-20 04:54 UTC

Closing by https://github.com/gonka-ai/gonka/pull/1482

🔄 Auto-synced from Issue #1167 every hour.