Comment 5 for bug 1702669
Revision history for this message
| Mark Shuttleworth (sabdfl) wrote Re: [Bug 1702669] Re: Index on maasserver_routable_pairs would improve performance | #5 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
Thanks Mike. Adding that index manually has definitely dropped the query
time. I was seeing the entry in the log every 2 minutes on average, even
with an idle MAAS.
What I am doing is logging postgres queries that take longer than a
threshold, currently 50ms. I will file bugs on those, then drop the
threshold to 40ms, and repeat.
My MAAS is small (20 nodes, 50 devices, 4 controllers) but I think as
part of the next cycle we should repeat this exercise using data from a
much larger MAAS.
Mark