Skip to content
TopicTracker
From HackerNewsView original
TranslationTranslation

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.