My sys ops team have recently handed over a brand new set of postgres clusters (prod, stage, test etc). We don't have any DBAs and they are under resourced. Mistakes in config have been found before. I'm not a DBA but I understand database concepts and I am happy to do some learning in my own time.
My principle concern is whether I am getting the expected level of performance given the hardware deployed (its all on prem).
I know that different applications will see different performance based on their queries and the stats of the dataset etc, but at least I would like to verify that the hardware, OS and postgres have been correctly installed and configured.
Where should I start? Ideally I could run some perf tests and at least verify that all the instances perform similarly. Is there a set of standard performance tests that I could run?