u/lazyantin r/PostgreSQL • Recommends
On “MSSQL DBA needs PostgreSQL skills asap”
review linux performance (here's a very brief intro [video ) for pg check if CPU is maxed out and also disk IO
for postgres, search for queries that give you table locks, slow queries ... there's tons of articles about tuning and performance