Comparison PostgreSQL vs MySQL database server

Both are open source databases. This is old debate. Yes no one can expect one database fits all your jobs.

To choose between the two databases, you need to understand whether you need the transaction support of Postgres or the large-text-area support in MySQL.

From the article:
It’s interesting that the two databases appear to be converging to meet in the middle somewhere. While MySQL is working on adding transaction support and slowly adding features like subselects, Postgres is making progress in the performance and stability.

It compare two databases using following points:

  • SQL standard COMPLIANCE
  • PLATFORMS
  • Speed
  • STABILITY
  • DATA INTEGRITY
  • SPECIAL server-side FEATURES
  • Security
  • LOCKING and CONCURRENCY SUPPORT
  • LARGE OBJECTS etc

A good read (little old too) but don’t forget to make some test running before selecting your database.


🐧 Get the latest tutorials on Linux, Open Source & DevOps via RSS feed or Weekly email newsletter.

🐧 1 comment so far... add one


CategoryList of Unix and Linux commands
Disk space analyzersdf duf ncdu pydf
File Managementcat cp mkdir tree
FirewallAlpine Awall CentOS 8 OpenSUSE RHEL 8 Ubuntu 16.04 Ubuntu 18.04 Ubuntu 20.04
Modern utilitiesbat exa
Network UtilitiesNetHogs dig host ip nmap
OpenVPNCentOS 7 CentOS 8 Debian 10 Debian 8/9 Ubuntu 18.04 Ubuntu 20.04
Package Managerapk apt
Processes Managementbg chroot cron disown fg glances gtop jobs killall kill pidof pstree pwdx time vtop
Searchingag grep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w
WireGuard VPNAlpine CentOS 8 Debian 10 Firewall Ubuntu 20.04
1 comment… add one

Leave a Reply

Your email address will not be published.

Use HTML <pre>...</pre> for code samples. Still have questions? Post it on our forum