postgres advantages
- table inheritance
- function overloading
- MVCC without read locks(offers advantages to write-heavy workloads)
- parallel query plans can use multiple CPUs/cores
- create index concurrently
- partial indexes(like create index xxx where …)
- advanced data types (array, geometric/GIS, network address types, JSONB which can be indexed, native UUID, timezone-aware timestamps).
postgres disadvantages (relative to mysql)
- less 3rd party tools
- read-heavy workflows