Fix CPU overload caused by PostgreSQL used by Java Spring backend

Posted 2 weeks ago

Worldwide

Summary

Our backend runs Java Spring + Hibernate + PostgreSQL DB on an Ubuntu server. We face issues on a server side periodically: CPU usage goes up to 100%, system CPU time rises as well while iowait stays the same. The issue lasts for a couple of days and then returns to the old normal levels. From what we understand it's not long queries execution, it's not the backend itself. Also it's not periodical schedulers or backup routines. It seems like it's smth inside Postgre DB while we do not see anything special in DB logs. We are looking for a specialist who has deep knowledge of how PostgreSQL works (especially in conjunction with Java Spring and Hibernate), has experience of optimization of interaction between the database and the backend software. If you apply for this job, please, include description of relevant experience resolving similar cases in your first message. I do not recommend to generate responses with AI tools as your accounts will be reported.

  • Less than 30 hrs/week
    Hourly
  • < 1 month
    Duration
  • Expert
    Experience Level
  • $40.00

    -

    $60.00

    Hourly
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Database Maintenance
Hibernate
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:2 weeks ago
  • Hires:
    1
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Nov 6, 2022
  • Poland
    Wroclaw12:08 AM
  • $5.9K total spent
    17 hires, 1 active
  • 113 hours

Explore similar jobs on Upwork

Set up sellers.json fileFixed-price‐ Posted 3 weeks ago
JSON
JavaScript
Advertising Networks
Application InstallationFixed-price‐ Posted 2 weeks ago
Android
Smartphone
Tablet
iPhone

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo