radimm

Writing some SQL for fun and profit, while enjoying PostgreSQL, Go and all things simple. Starting SQL Labs for boringSQL.

radim [at] boringsql [dot] com

Posts

• Beyond the Basics of Logical Replication
  by radimmon 6/24/2025, 6:47 AMwith 0 comments
• First Steps with Logical Replication in PostgreSQL
  by radimmon 6/16/2025, 7:45 AMwith 0 comments
• PostgreSQL Service Connections
  by radimmon 5/16/2025, 7:12 AMwith 0 comments
• Why PostgreSQL major version upgrades are hard
  by radimmon 11/27/2024, 1:24 PMwith 0 comments
• DELETEs Are Difficult
  by radimmon 11/25/2024, 6:46 AMwith 115 comments
• Beyond Simple Upserts with Merge in PostgreSQL
  by radimmon 8/26/2024, 8:15 AMwith 0 comments
• Gentle Introduction to Window Functions in PostgreSQL
  by radimmon 7/8/2024, 7:28 AMwith 0 comments
• The time keepers: pg_cron and pg_timetable
  by radimmon 6/17/2024, 7:05 AMwith 17 comments
• PostgREST Tutorial: APIs made easy
  by radimmon 6/10/2024, 6:49 AMwith 18 comments
• Custom PostgreSQL Extensions with Rust
  by radimmon 5/28/2024, 7:53 AMwith 0 comments
• Scaling Clubhouse From 10K to 10M Users In 6 Months With Postgres
  by radimmon 5/17/2024, 7:28 PMwith 3 comments
• How not to change PostgreSQL column type
  by radimmon 5/6/2024, 6:27 AMwith 0 comments
• The Bloat Busters: pg_repack vs. pg_squeeze
  by radimmon 4/28/2024, 6:17 AMwith 12 comments
• When and Why PostgreSQL Indexes Are Ignored
  by radimmon 4/23/2024, 6:28 PMwith 0 comments