Why to choose PostgreSQL over MySQL ? Is PostgreSQL faster ?

Question

Why to choose PostgreSQL over MySQL ? Is PostgreSQL faster ?

Why to choose PostgreSQL over MySQL or Maria DB ? Is PostgreSQL faster ?

0

Report

12 Dec 2022 at 06:23 PM

corson

mysql

postgresql

sql

1 answer

OK

Tim · Answer 1

Hi,

PostgreSQL is an object-relational database, while MySQL and MariaDB are purely relational databases.

Advantages of PostgreSQL:

Object oriented relational database (ORDBMS)
Supports more data types (arrays, json, maps etc.)
Offers more features (like Table partitioning, Point in time recovery etc.)
Is more suitable for using of complex queries and frequent write operations
Multi-version concurrency control

PostgreSQL can be faster mainly when making a complex operations. If you do mostly simple operations, you can get better performance with MySQL or MariaDB. These databases are more suitable for standard websites.

Why to choose PostgreSQL over MySQL ? Is PostgreSQL faster ?

mysql

postgresql

sql

Incorrect integer value '' for column 'user_id' at row 1 - error

Fatal error: Call to undefined function mysql_query() - PHP

Error: Illegal parameter data types INT and row for operation '='

Is faster one big SQL query or multiple small SQL queries ?

Fatal error: Call to undefined function mysql_connect() - PHP

Fix error: mysqli_select_db / query expects 2 arguments, 1 given

Copy and update rows in the same table with autoincrement - SQL