Postgres
The index that did nothing: reading an EXPLAIN plan line by line
We added an index to fix a 1.2 second query and the plan did not change. Here is how EXPLAIN ANALYZE told us why, and the partial index that worked.
Page 2 of 2
Green Build Gazette is a group engineering blog about Postgres, Node, Go, testing and reliability, written by four developers who run production.
We added an index to fix a 1.2 second query and the plan did not change. Here is how EXPLAIN ANALYZE told us why, and the partial index that worked.
Exponential backoff without jitter turns one outage into synchronized waves of retries. Here is a small Go helper that gets backoff, jitter and cancellation right.
Webhook providers deliver at least once, so your handler will see duplicates. A unique key and one transaction in Postgres make that harmless.