pgstack-io/pgstack
View on GitHub ↗ ★ 1,538 Go
Postgres read replicas for Search and Audit
10 mentions on Hacker News by 3 people: 4 stories, 6 comments · first 2024-11-07 · latest 2026-01-08
20082026
-
…locked in. We’d love your feedback! Check us out at https://bemidb.com and our open source repo at https://github.com/BemiHQ/BemiDB . What do you think?
comment by exAspArk · 2025-01-30 · in BemiDB – Zero-ETL Analytics on Postgres -
…We're starting to work on CDC with logical replication for incremental syncing. Here is our roadmap https://github.com/BemiHQ/BemiDB#future-roadmap
comment by exAspArk · 2024-11-08 · in Show HN: BemiDB – Postgres read replica optimized for analytics -
Looking at the syncer it seems like copying data to csv from the whole table everytime (?) Code: https://github.com/BemiHQ/BemiDB/blob/6d6689b392ce6192fe521a... I cant imagine until at what scale can you do this and is there anything…
comment by banditelol · 2024-11-08 · in Show HN: BemiDB – Postgres read replica optimized for analytics -
…I haven't used the DBT-3 kit, does it add any indexes? I manually added these Postgres indexes https://github.com/BemiHQ/BemiDB/blob/main/benchmark/data/cr... to reduce the main bottlenecks on SF0.1 and reduce the total time from 1h23m13s…
comment by exAspArk · 2024-11-07 · in Show HN: BemiDB – Postgres read replica optimized for analytics -
^ This! Here is the link that briefly describes pros and cons of different alternatives for analytics https://github.com/BemiHQ/BemiDB#alternatives
comment by exAspArk · 2024-11-07 · in Show HN: BemiDB – Postgres read replica optimized for analytics -
We ran some benchmarks (TPC-H, designed for OLAP) with ~10M records https://github.com/BemiHQ/BemiDB#benchmark The BemiDB storage layer produced ~300MB columnar Parquet files (with ZSTD compression) vs 1.6GB of data in Postgres.
comment by exAspArk · 2024-11-07 · in Show HN: BemiDB – Postgres read replica optimized for analytics