performance degradation for database execution times

Bug #1202321 reported by Corey Goldberg
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Canonical SSO provider
Won't Fix
High
Unassigned

Bug Description

looking at SSO database performance graphs (for Production)...
in early July we saw an increase in execution times against our postgres db.
Mean execution time went from ~1.5ms to ~3.5ms (still very fast, but a large percentage increase).
higher latency can also be seen in the 99th percentile time graph.

see attached screenshot of graphs for more context.

possibly related:
there was an OS (lucid to precise) upgrade and Postgres DB upgrade on July 3, which coincides with the performance degradation.

description: updated
Julien Funk (jaboing)
Changed in canonical-identity-provider:
importance: Undecided → High
assignee: nobody → Ricardo Kirkner (ricardokirkner)
status: New → Confirmed
Dave Morley (davmor2)
tags: added: u1-notrack
Daniel Manrique (roadmr)
Changed in canonical-identity-provider:
assignee: Ricardo Kirkner (ricardokirkner) → nobody
status: Confirmed → Won't Fix
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.