Procore Engineering Blog
  • Home
  • About
  • Engineering
  • Careers
Sign in Subscribe
Jeff Frost

Jeff Frost

Data

DAD eliminates top DB CPU consumer with a single environment variable

The Database Admin (DAD) team is responsible for DB performance, and let’s just say Procore’s growth is keeping us pretty busy. We recently noticed that SET application_name = ? has been climbing the ranks of RDS Performance Insights [https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Overview.
Feb 18, 2021 3 min read

How to Make a Query 280,000 Times Faster

We usually make small iterative improvements in performance. However, on rare occasions, an opportunity arises to make an improvement of five orders of magnitude by changing a single line! After learning about a slow query that was hitting our statement timeout from one of our Site Reliability Engineers, I reformatted
Dec 1, 2020 1 min read
Page 1 of 1
Procore Engineering Blog © 2023
Powered by Ghost