article thumbnail

PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)

Percona

This analyze can be skipped by setting this to false and help increase the speed of moving large amounts of data. DEFAULT ‘on’::text Because we specified ‘2’ for premake in the create_parent function, you can observe that two partitions ahead have been created, as shown in the table definition below.

Storage 101