Postgres isn't always perfect and for a few things lagged behind for a few years (namely upsert and better replication support). Fortunately we got both of thes

Postgres isn't always perfect and for a few things lagged behind for a few years (namely upsert and better replication support). Fortunately we got both of these in recent releases, but this post is a great collection of areas where it already shined with some powerful features. In particular really love the details on check constraints and null in Postgres.