Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

Poor query performance after upgrading from Aurora PostgreSQL 12 to 13

0

After upgrading aws aurora postgresql 12 to 13.6 last night, the performance of the database went crazy. The cpu load is in the skies, and simple queries take minutes which were supposed to be under seconds just yesterday. I feel like this is some sort of misconfiguration, or I really hope so that some magic will resolve the case.

The performance of the queries is related to the size of a database, but in a strange exponential manner. On demo data, the queries perform as they were previously, but on production data they get significantly worse. Can this not be some resource limit of the workers?

I don't even know where to look, I'm just running the queries which were working yesterday. Could you help out?

Themen
DatenbankAWS Framework mit guter Struktur
Tags
PostgreSQLAurora PostgreSQLLeistungseffizienz
Sprache
English
balintb
gefragt vor 2 Jahren2333 Aufrufe
2 Antworten
3

Okay, it was the ANALYZE; command that solved the problem. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion

balintb
beantwortet vor 2 Jahren
  • Brad
    vor 5 Monaten

    Thank you! This solved the same issue for me.

0

Yes I experienced the same drop in performance for my website to get Excel stock price. I think it had something to do with the number of requests we handle.

AWS-User-1617512
beantwortet vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt