electric-sql / electric-sql/electric

sync-service: Make sqlite durabilty and page cache size configurable

Open
#3,824 0 comments 0 reactions 1 assignee Claimed by @magnetised View on GitHub
Dominant language
TypeScript
Stars
10.4k
Forks
375
Avg merge
3d 1h
Merged PRs (30d)
18

Description

I've dropped the durability of the sqlite shape db from "normal" (where wal appends are fsynced) to "off" where all writes just live in the kernel page cache until automatically flushed and bumped each connection's page cache size to 4MiB to improve performance on EBS volumes.

This is a quick fix - these values should have different defaults (normal durability and a lower page cache) so we need to add config params for this.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.