After effect of Postgres DB upgrade
The Story: Client reported that one of the reports which was getting generated in 15-20 mins is not taking ours. We tried analysing the RDS performance insight and came to know IO:DataFileRead is taking time. Recently we upgraded the Postgres version from 12 to 15 on two of our projects. We had two possible causes(still a theory) Recently we upgraded the Postgres version from 12 to 15 on two of our projects. It can be the root cause. ...