pgpartman/pg_partman

Allow partitions to be created in separate schema

feature request

#509

· revoohc opened

on Feb 15, 2023

Add sub partition by HASH(column)

help wanted

#346

· bilby91 opened

on Mar 24, 2021

Create separate background worker to analyze partition sets

feature request

#514

· keithf4 opened

on Mar 22, 2023

Create index removal procedure

feature request

#515

· keithf4 opened

on Mar 22, 2023

Session level variables for BGW (Was: Create partitions with default access method)

feature request

help wanted

#457

· gferrette opened

on May 5, 2022

Run partition_data_proc in parallel

feature request

help wanted

#463

· maxpain opened

on May 28, 2022

Support for multi-column partitioning

feature request

#516

· keithf4 opened

on Mar 23, 2023

Support for uuid7 or ulid

feature request

fixed in current release

help wanted

#528

· dahu33 opened

on May 24, 2023

Provide Checksum for GitHub Archives

feature request

#583

· Morl99 opened

on Oct 26, 2023

Can partman inherit the same access method from template table?

feature request

#571

· lij55 opened

on Sep 14, 2023

Specify regex for background worker dbname

feature request

help wanted

#467

· frankhommers opened

on Jun 8, 2022

Question - Why should sub-partition interval be smaller than parent interval

feature request

#695

· fobbing opened

on Oct 3, 2024

Use of special types like <code>regclass</code> in <code>part_config*</code> and functions

documentation

feature request

#540

· vitaly-burovoy opened

on Jun 27, 2023

Regarding run_maintenance_proc() with concurrently option for detaching tables

feature request

help wanted

#677

· Durgamahesh671 opened

on Jul 20, 2024

Support for time-based integer IDs (e.g. snowflake) using encode/decode

feature request

#729

· calebj opened

on Jan 6, 2025

Get upper boundary from catalog vs calculating it (WAS: show_partition_info is miscalculating boundaries)

feature request

help wanted

#765

· jw1u1 opened

on Apr 3, 2025

Run_Maintenance failing with invalid input syntax for type timestamp with time zone: "MINVALUE"

feature request

#769

· dmahto05 opened

on Apr 15, 2025

Templating child partition names

feature request

#773

· bolajiwahab opened

on Apr 25, 2025

Partman behaves unexpectedly when partition size is changed, leaving gaps

feature request

help wanted

#809

· smcgivern opened

on Sep 18, 2025

Add support to configure per-column statistics-gathering target while creating partition

feature request

#810

· chopraanmol1 opened

on Sep 24, 2025

partition_data_async better implementation

feature request

#827

· keithf4 opened

on Nov 4, 2025

reapply_indexes.py does not work with PG11

feature request

#238

· keithf4 opened

on Nov 6, 2018

partition_data_proc(): timestamp (no tz) control leaves rows in DEFAULT on pg_partman 5.4.0 (PG17.4), causing “updated partition constraint … would be violated” (works on 5.2.4 / PG14.11)

confirmed bug

fixed in next release

#838

· code-and-such opened

on Jan 26, 2026

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Future

Allow partitions to be created in separate schema

Add sub partition by HASH(column)

Create separate background worker to analyze partition sets

Create index removal procedure

Session level variables for BGW (Was: Create partitions with default access method)

Run partition_data_proc in parallel

Add Docker test environment for easy development.

Support for multi-column partitioning

Support for uuid7 or ulid

Provide Checksum for GitHub Archives

Can partman inherit the same access method from template table?

Specify regex for background worker dbname

Question - Why should sub-partition interval be smaller than parent interval

Use of special types like <code>regclass</code> in <code>part_config*</code> and functions

Regarding run_maintenance_proc() with concurrently option for detaching tables

Support for time-based integer IDs (e.g. snowflake) using encode/decode

Implement encode/decode for ID columns

Get upper boundary from catalog vs calculating it (WAS: show_partition_info is miscalculating boundaries)

Run_Maintenance failing with invalid input syntax for type timestamp with time zone: "MINVALUE"

Templating child partition names

Partman behaves unexpectedly when partition size is changed, leaving gaps

Add support to configure per-column statistics-gathering target while creating partition

partition_data_async better implementation

reapply_indexes.py does not work with PG11

partition_data_proc(): timestamp (no tz) control leaves rows in DEFAULT on pg_partman 5.4.0 (PG17.4), causing “updated partition constraint … would be violated” (works on 5.2.4 / PG14.11)

Future

List view