Deadlocks on insert (in production) about pulse HOT 1 CLOSED

Hey @joelvh,

Pulse relies on upsert queries to pre-aggregate data into buckets. If you have enough traffic, multiple queries can try to update the same aggregate row at the same time. The upserts are delayed until after the HTTP response has been sent to the browser, so it shouldn't impact the request. However, it can tie up the web worker with extra work before it can handle another request.

In these cases, we recommend using the Redis Ingest. It allows your web workers to quickly dump the metrics onto a Redis stream and then a single background process can batch insert them into the database without having to fight other processes.

from pulse.