Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

Remove locked upsert on e2e_device_keys_json #4015

Closed
erikjohnston opened this issue Oct 8, 2018 · 4 comments
Closed

Remove locked upsert on e2e_device_keys_json #4015

erikjohnston opened this issue Oct 8, 2018 · 4 comments
Assignees
@hawkowl
Labels
A-Performance Performance, both client-facing and admin-facing

Comments

@erikjohnston
Copy link
Member

We upsert frequently enough that it stops the postgres autovacuum, which eventually leads to postgres blocking the upserts (which in turn then end up wedging the DB pool)
@neilisfragile neilisfragile added p1 A-Performance Performance, both client-facing and admin-facing labels Oct 8, 2018
@richvdh
Copy link
Member

richvdh commented Nov 22, 2018

this happened again last night

@hawkowl hawkowl mentioned this issue Dec 18, 2018
Merged
@hawkowl hawkowl mentioned this issue Jan 9, 2019
Closed
@anoadragon453
Copy link
Member

This good to close now that #4306 is merged?

@richvdh
Copy link
Member

richvdh commented Jan 26, 2019

let's keep it open until #4306 is deployed, since it just took everything out for 15 minutes

@richvdh
Copy link
Member

richvdh commented Jan 31, 2019

fixed by #4306 \o/

@richvdh richvdh closed this as completed Jan 31, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@hawkowl hawkowl

Labels
A-Performance Performance, both client-facing and admin-facing
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@neilisfragile @anoadragon453 @richvdh @hawkowl @erikjohnston