I got asked this question recently:
I constantly see PostgreSQL on Microsoft slides, email, ads, etc. My MCADAA exam started with an entire section on it. I’m trying to determine if it’s worth focused study and training time. Roughly how much of the Azure cloud database space does PostgreSQL occupy? Should I include it in my personal training program?
It’s a good question, though I am assuming that MCADDA is the Microsoft Certified: Azure Database Administrator Associate cert. That page describing the exam only mentions Azure SQL (SQL Server), and not PostgreSQL, so while I think Azure SQL for PostgreSQL is good to learn, I think the cert preparation needs an update if that topic is on the exam.
In any case, should you learn PostgreSQL?
I’ll give you the DBA answer: it depends.
Ask yourself some questions:
- Does your org use PostgreSQL or are they planning to do so?
- Are you going to stick with your company for a few more years?
- Are there more things you should be learning in the area you do work now?
- Are there things you should become more skilled at that your company values?
- Do you know what the opportunities are for people that know PostgreSQL well?
Depending on the answers, I may or may not recommend you spend time there. If you have other things to learn that might be better at your current job, either the job you have or one you might want, then focus there. If your company does (or doesn’t) value PostgreSQL, then that influences your choice as well.
PostgreSQL is growing fast. DB-Engines shows growth across a few platforms, and PostgreSQL is doing well.
The StackOverflow developer survey shows similar results:
However, those are general results. Your specific situation is different. Think about it and ask the question above to lots of people.