Jira (PDB-5567) Migrate PDB reports and resource_events inheritance based partitions to postgresql declarative partitions

[Joshua Partlow (Jira)]

Title: Message Title

Joshua Partlow updated an issue   PuppetDB / PDB-5567 Migrate PDB reports and resource_events inheritance based partitions to postgresql declarative partitions Change By: Joshua Partlow PDB-5554 intended to improve performance around partition remove by making use of `alter table detach partition concurrently`. But that can only be used with declarative partitions and our partitions are inheritance based. Migrate resource_events and reports partitioning to [declarative partitions|https://www.postgresql.org/docs/current/ddl-partitioning.html]. [https://www.2ndquadrant.com/en/blog/how-to-migrate-from-inheritance-based-partitioning-to-declarative-partitioning-in-postgresql/] is one example. Need to validate that this migration won't have a significant impact on larger databases with a significant number of reports and events. NOTE: * The minimum PostgreSQL version is now 11 with these migrations. * Add Comment   This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.475715.1669757045000.7709.1675469760078%40Atlassian.JIRA.