Postgresql

There are only 2 ways to make money. Increase your income or reduce your expense. Its true for inidividual as well as organizations. In my current organization we were facing huge challenge of unncessary cost being spent on AWS. We were paying huge chunk of our income to AWS. In this post I am going to disect some critical problems and optimizations done to reduce the cost of the AWS. ...

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. ...