How It Works


#Postgres

3 posts tagged "Postgres"

🦉 The Outbox Without an Outbox — Postgres Logical Messages as Eventbus

~35 min

The outbox pattern asks for what replication already provides — durable, ordered, resumable delivery. Postgres' pg_logical_emit_message lets your application piggyback on that, walked line by line through factlib + OwlPost.

🚂 Temporal — Under the Hood

~36 min

What actually happens when you start a Temporal workflow? We trace every SQL statement, count the event-history nodes, and then watch Absurd — a 5-table, single-SQL-file system — do the same job with one-fifth the queries and twenty-times the throughput.

🐘 Postgres - Optimising query

~4 min

Optimize your PostgreSQL queries with these techniques to improve performance: using indexes, analyzing data, utilizing EXPLAIN, avoiding SELECT *, implementing LIMIT, optimizing JOINs, and considering caching.


← all tags