SQL Database, Table and Data Partitioning: When and How to Do It

Table partitioning is a complex but useful concept. Read this post to better understand partitioning, why you need partitioning and the steps you need for PostgreSQL, BigQuery and MS SQL Server databases.