Postgres

2 Results

Debugging deadlocks in Postgres | Blog

ByDr. Mercy Nwankwo February 5, 2025February 5, 2025Write a Comment

ERROR: deadlock detected (SQLSTATE 40P01) What steps should you take when encountering this error? Deadlocks are a common challenge in backend development, but by investigating and designing carefully, they can […]

Incident Management

Choosing the right Postgres indexes | Blog

ByDr. Mercy Nwankwo October 29, 2024October 29, 2024Write a Comment

Indexes play a crucial role in improving performance in Postgres, but it’s not always easy to know when a query could benefit from an index. Here, we’ll explore: What indexes […]