Write-ahead logging

And PostgreSQL can actually handle the relentless active message queue polling.

Without breaking a sweat, PostgreSQL provides ACID guarantees and utilizes write-ahead logging, or WAL.

Because Kestra stores all execution state in the repository database, PostgreSQL ensures that if your power cuts out abruptly, the database recovers cleanly on the next boot.

Because of the write-ahead log.

Right.

The WAL replays the incomplete transactions, and your pipeline graphs aren't corrupted.

It fits perfectly within that 4GB RAM envelope we talked about, leaving about 1.5GB to 2GB of free dynamic headroom on the host for when tasks actually need to process data.

So standalone with Postgresible gives you enterprise durability without the microservice memory task.