Footguns with Postgres "at time zone 'UTC'"
Summary
The article discusses common mistakes and pitfalls when using the 'at time zone UTC' function in PostgreSQL for timezone conversions.
Similar Articles
British Columbia, Time Zones, and Postgres
Discusses how British Columbia's permanent switch to Pacific Daylight Time in 2026 affects PostgreSQL timestamp storage, and provides best practices to avoid time zone shift errors using a dual-column pattern.
Looking Forward to Postgres 19: It's About Time
PostgreSQL 19 is finally introducing native temporal table support following the SQL:2011 standard, replacing the old manual approach with exclusion constraints. The article explains the limitations of the current method and the long-awaited benefits of the new feature.
@GergelyOrosz: Actually - no. This is why every and any sane software engineer uses 1) Utc timestamps (no daylight savings) or Epoch t…
Gergely Orosz emphasizes the importance of using UTC timestamps or epoch time along with proper date libraries to handle time zones and daylight saving time correctly.
Postgres by Example
A hands-on introduction to PostgreSQL using annotated SQL examples, covering basics to advanced topics.
Potential Consequences of Using Postgres as a Job Queue
The article analyzes the scalability limitations of using PostgreSQL as a job queue, specifically highlighting performance bottlenecks caused by MultiXact SLRU contention under high concurrency. It explains why this architecture fails in production despite working well in development and suggests considering alternatives.