Recent Posts

• Select FOR UPDATE considered harmful in PostgreSQL
  by samokhvalovon 6/19/2025, 5:41:25 PM with 2 comments
• Vertical Sharding Sucks
  by samokhvalovon 4/12/2025, 3:49:49 AM with 8 comments
• Impact of Partitioning on Planning Time in Postgres
  by samokhvalovon 10/7/2024, 5:24:25 PM with 0 comments
• Number of partitions vs. planning time in Postgres
  by samokhvalovon 10/4/2024, 1:23:05 AM with 0 comments
• Why Postgres Extensions should be packaged and distributed as OCI images
  by samokhvalovon 4/3/2024, 4:15:22 PM with 0 comments
• Ask HN: Best way to set up self-managed Postgres clusters?
  by samokhvalovon 3/24/2024, 6:26:15 PM with 7 comments
• Postgres.ai Bot
  by samokhvalovon 1/31/2024, 10:20:51 PM with 1 comment
• Avoid Over-Indexing in Postgres
  by samokhvalovon 10/14/2023, 7:27:22 AM with 0 comments
• Intercom's ChatGPT-based support bot
  by samokhvalovon 3/21/2023, 7:15:25 PM with 1 comment
• Postgres Schema Change Mistakes
  by samokhvalovon 3/3/2023, 5:56:51 PM with 1 comment
• Continuous Profiling with Coroot and Pyroscope
  by samokhvalovon 3/2/2023, 9:39:46 PM with 0 comments
• BPF-based lock tracer for the Postgres
  by samokhvalovon 1/23/2023, 11:53:21 PM with 0 comments
• Postgres: Safely renaming a table with no downtime using updatable views
  by samokhvalovon 11/28/2022, 9:30:30 PM with 0 comments