DiscoverThe Backend Engineering Show with Hussein NasserThey Enabled Postgres Partitioning and their Backend fell apart
They Enabled Postgres Partitioning and their Backend fell apart

They Enabled Postgres Partitioning and their Backend fell apart

Update: 2023-06-24
Share

Description

In a wonderful blog, Kyle explores the pains he faced managing a Postgres instance for a startup he works for and how enabling partitioning sigintfically created wait events causing the backend and subsequently NGINX to through 500 errors.

We discuss this in this video/podcast

https://www.kylehailey.com/post/postgres-partition-pains-lockmanager-waits
Comments 
loading
00:00
00:00
1.0x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

They Enabled Postgres Partitioning and their Backend fell apart

They Enabled Postgres Partitioning and their Backend fell apart

Hussein Nasser