PostgreSQL: Partitioned Table vs Non Partitioned Table (Part 3)
This article compares the speed and performance of queries between partitioned and non partitioned PostgreSQL tables. However, it is...
Read MorePHP Script to Generate PostgreSQL Table Partitioning (Part 2)
As Part 1 (Howto create PostgreSQL table partitioning) shows, making of PostgreSQL partitioning needs a lot of SQL commands. So this Part 2...
Read MoreCreate PostgreSQL Table Partitioning (Part 1)
PostgreSQL supports partitioning via table inheritance. So the partitioning is made in such a way that every child table inherits single...
Read MorePartitioning PostgreSQL Tables – Handle Millions of Rows Efficiently
PostgreSQL table partitioning means splitting one large database table into smaller logical pieces. PostgreSQL table partitioning will be...
Read More