Should I Learn PostgreSQL

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.

2024-10_0140

The StackOverflow developer survey shows similar results:

2024-10_0141

However, those are general results. Your specific situation is different. Think about it and ask the question above to lots of people.

Unknown's avatar

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

2 Responses to Should I Learn PostgreSQL

  1. Thom A's avatar Thom A says:

    Interesting how different Oracle is rated on thise 2 graphs; on the first it ranked top, but on Stack Overflow the usage is *significantly* lower.

    I’ve not actually encountered PostgreSQL in a professional environment at all so far. There were talks of Snowflake coming on board, but that discussion hasn’t come up in awhile, so I’m assuming it’s not coming any more.

    Like

    • way0utwest's avatar way0utwest says:

      You might see that in some places. Not everywhere is using multiple platforms, but most are. We see many clients using at least 2. PostgreSQL (et al Planetscale, aurora, etc.) is very popular.

      Like

Comments are closed.