Real Postgres event store integration tests on VPS

ash commented

2026-02-19 21:27:40 +00:00

Owner

What

The pgstore package has tests but they may use mocks. Need real Postgres integration tests.

Tasks

Test against real Postgres on VPS (143.14.50.71)
Test concurrent writers + sequence gap behavior
Test pg_snapshot visibility approach vs published sequence table
Benchmark all read patterns with 1M events
Test LISTEN/NOTIFY for PostgresNotifier
Document performance characteristics

## What The pgstore package has tests but they may use mocks. Need real Postgres integration tests. ## Tasks - [ ] Test against real Postgres on VPS (143.14.50.71) - [ ] Test concurrent writers + sequence gap behavior - [ ] Test pg_snapshot visibility approach vs published sequence table - [ ] Benchmark all read patterns with 1M events - [ ] Test LISTEN/NOTIFY for PostgresNotifier - [ ] Document performance characteristics

ash added the

testing

performance

production-ready

labels

2026-02-19 21:27:40 +00:00

ash referenced this issue from a commit

2026-02-19 21:51:53 +00:00

test(pgstore,natsstore): add conformance suite wiring

ash referenced this issue from a commit

2026-02-19 22:48:27 +00:00

feat(pgstore): add PG clustering, LISTEN/NOTIFY, competing projections (#31, #6, #3)

ash commented

2026-02-20 08:16:56 +00:00

Author

Owner

Real Postgres integration tests passing on VPS: conformance suite, concurrent writers (10 goroutines), 100K events (674 writes/sec, 110K reads/sec), advisory locks, LISTEN/NOTIFY, global reader, competing projections, checkpoints. BinaryLikeData test fixed for JSON UTF-8 limitation.

ash closed this issue

2026-02-20 08:16:56 +00:00

ash commented

2026-02-20 08:17:04 +00:00

Author

Owner

Real Postgres integration tests passing on VPS.

ash referenced this issue

2026-02-20 11:39:44 +00:00

feat: add EventType string field to Event[E] #51

ash referenced this issue from a commit

2026-03-10 14:40:46 +00:00