We configured Azure database for PostgreSQL server with performance configuration like: General Purpose, 4 vCore(s), 100 GB
We currently have data in database of only around 1 GB and we have not scaled our application cause it is not required as of now.
The performance of PostgreSQL is very low. It is taking around 15 to 30 second in simple query to execute from PG Admin as well.
Can you please help us to get it resolved?
Can we edit performance configuration if so then how?