Don't Do These Things in Postgres — An interesting page on the official Postgres wiki that attempts to round up a variety of ‘common mistakes’ in using Postgres, such as “Don’t use char(n)” and “Don’t use serial“. Some of these are opinionated, but are well backed up with reasons.
Appears in lists (1)
More like this (2)
PERIODs and SYSTEM VERSIONING for Postgres — Periods are a SQL:2016 feature that are a bit...
Don’t Forget the Benefits of BRIN Indexes — BRIN indexes (which provide an efficient way to...