Discussions

• 2 You must be logged in to vote

  🙏

  FK on partitioned table when PK is not part of the partition column (AKA template)

  Asafb26 asked Mar 10, 2024 in Q&A · Unanswered

  

  

  

  

  9
• 1 You must be logged in to vote

  🙏

  LIST partitioned table does not get new partitions with run_maintenance* calls

  kmustkivi asked Nov 12, 2024 in Q&A · Closed · Unanswered

  

  

  1
• 1 You must be logged in to vote

  🙏

  Better script to migrate existing partitions to partman?

  Faithfinder asked Nov 14, 2024 in Q&A · Unanswered

  

  

  1
• 1 You must be logged in to vote

  🙏

  Creation works but Deletion is not working after successful job run

  Rammurthy5 asked Oct 24, 2024 in Q&A · Answered

  

  

  3
• 1 You must be logged in to vote

  🙏

  Encountering ERROR: native is not a valid partitioning type for pg_partman

  danqiye1 asked Sep 24, 2024 in Q&A · Answered

  

  

  1
• 1 You must be logged in to vote

  🙏

  I have a timestamp without timezone data type column in my table and pg_partman fails to create partition

  Rammurthy5 asked Oct 23, 2024 in Q&A · Answered

  

  

  1
• 1 You must be logged in to vote

  🙏

  Does pg_partman support PG major version 17?

  jasonchenTJ asked Sep 29, 2024 in Q&A · Answered

  

  

  1
• 1 You must be logged in to vote

  🙏

  All Partitions are hit when predicate contains multiple timestamp columns

  ndchandar asked Sep 6, 2024 in Q&A · Unanswered

  

  

  2
• 1 You must be logged in to vote

  🙏

  What lock will be acquired when creating new partition

  jhchee asked Sep 4, 2024 in Q&A · Answered

  

  

  2
• 1 You must be logged in to vote

  🙏

  Migration question

  doruiulian asked Aug 29, 2024 in Q&A · Answered

  

  

  2
• 1 You must be logged in to vote

  🙏

  Does run_maintenance() require all partitions for a parent table to be managed by pg_partman?

  TonyJulin asked Jul 15, 2024 in Q&A · Answered

  

  

  4
• 1 You must be logged in to vote

  🙏

  Question on creating different partition intervals for the same parent_table

  TonyJulin asked Jul 11, 2024 in Q&A · Unanswered

  

  

  5
• 1 You must be logged in to vote

  🙏

  Missing Records while trasfer data from main table to children

  Thavarajan asked Jun 6, 2024 in Q&A · Answered

  

  

  10
• 1 You must be logged in to vote

  💬

  Need to migrate large amount of data from default

  CharlesLiu02 started Jun 7, 2024 in General

  

  

  10
• 1 You must be logged in to vote

  💬

  CREATE EXTENSION pg_partman WITH SCHEMA partman; ERROR: extension "pg_partman" has no installation script nor update path for version "5.1.0"

  vipvdj started May 16, 2024 in General

  

  

  1
• 1 You must be logged in to vote

  🙏

  how can we use pg_partman for postgres on windows

  help wanted

  gr185136 asked Apr 27, 2022 in Q&A · Unanswered

  

  

  

  

  3
• 1 You must be logged in to vote

  🙏

  Using the create_parent function

  christiansalako asked Apr 18, 2024 in Q&A · Answered

  

  

  8
• 1 You must be logged in to vote

  💬

  what is the correct way to rename partitioned table?

  virajbz started Apr 7, 2024 in General · Closed

  

  

  4
• 1 You must be logged in to vote

  💬

  Install for GitHub Actions?

  jeremyhaile started Mar 26, 2024 in General · Closed

  

  

  4
• 1 You must be logged in to vote

  🙏

  GROUP BY partitioned_table.id not working anymore after partitioning

  gitmalong asked Mar 3, 2024 in Q&A · Answered

  

  

  2
• 1 You must be logged in to vote

  🙏

  Is there a recommended pg_partman naming convention for integer range partitioning?

  rgidds asked Feb 20, 2024 in Q&A · Answered

  

  

  2
• 1 You must be logged in to vote

  🙏

  Installation possible on macOS?

  help wanted

  jambudipa asked Jun 21, 2023 in Q&A · Answered

  

  

  

  

  7
• 1 You must be logged in to vote

  💬

  Ideal number of partitions for data purge

  kushagk started Feb 21, 2024 in General

  

  

  13
• 1 You must be logged in to vote

  🙏

  custom autovacuum settings at table level for new partitions

  tahseenbaig asked Feb 9, 2024 in Q&A · Answered

  

  

  2
• 1 You must be logged in to vote

  💬

  Handling Indexes for Partitions Created in Flyway Migrations

  vbhosle started Feb 2, 2024 in General

  

  

  1