Postgres FM

Timestamps

Dec 9, 2022
Discussion on using timestamp with time zone data type in PostgreSQL, benefits and challenges of timestamps, introduction to B3 indexes and brain indexes in Postgres, advantages of using timestamps rather than boolean columns in databases, exploration of timestamps, time intervals, and infinity.
Ask episode
Chapters
Transcript
Episode notes
1
Introduction
00:00 • 3min
2
Benefits and Challenges of Timestamps in PostgreSQL
03:04 • 7min
3
Understanding B3 Indexes and Brain Indexes in Postgres
10:28 • 12min
4
Using a Timestamp Instead of Boolean Column in Database
22:03 • 2min
5
Timestamps, Time Intervals, and Infinity
24:06 • 2min