Skip to content
This repository has been archived by the owner on Jul 30, 2023. It is now read-only.

Support unpacking to PostgreSQL #22

Open
riptl opened this issue Jul 15, 2022 · 0 comments
Open

Support unpacking to PostgreSQL #22

riptl opened this issue Jul 15, 2022 · 0 comments

Comments

@riptl
Copy link
Owner

riptl commented Jul 15, 2022

SQLite is just too slow, even when configuring it to do multi-threaded (WAL) insertion. It currently takes multiple hours to load a full snapshot into SQLite.

Experiments have shown that a moderately sized Postgres instances (64 GB RAM; 16 vcores) can load a full snapshot in ~20 minutes, and scales almost linearly with server size.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant