How soon is now in PostgreSQL?
PostgreSQL's `now()` returns the transaction start time, not the real-time clock. The article explains how to use `clock_timestamp()`, `statement_timestamp()`, and `now()` correctly for event-driven systems, and warns against relying on `now()` for precise ordering in asynchronous event sourcing.