News for hackers. Stuff that matters.

kuvasz-io

It also takes care of setting up publications, replication slots and the initial sync.
The mystery shall remain
No guarantees on latency as this depends on the hardware.

Check the load test

https://kuvasz.io/kuvasz-streamer-load-test/

The date fields are actually timestamps having microsecond accuracy. Maybe this was not clear in the docs.

       1 | 12  |  1 | r1   |        | 1900-01-01 00:00:00+00        | 2025-01-07 21:15:49.233384+00 | f
       7 | 12  |  2 | r2   |        | 1900-01-01 00:00:00+00        | 2025-01-07 21:15:49.233384+00 | f
      13 | 12  |  1 | x1   |        | 2025-01-07 21:15:49.233384+00 | 9999-01-01 00:00:00+00        | f
kuvasz-streamer batches updates in a single timed transaction (1 second for example). This is independent of the source transaction.

I have seen a significant increase in performance with this feature.

Show HN: Kuvasz-Streamer a Change Data Capture for Postgres Tool

https://github.com/kuvasz-io/kuvasz-streamer

Kuvasz-streamer is an open source change data capture (CDC) project that focuses exclusively on Postgres. It is tightly integrated with Postgres Logical Replication to provide high performance, low latency replication. Use it for database consolidation in a data warehouse, major version upgrade and performance optimization.

( Read More... | no comments | on HN )