Jira (PDB-5552) Improve the removal of old reports partitions

1 view
Skip to first unread message

Austin Blatt (Jira)

unread,
Oct 20, 2022, 4:57:02 PM10/20/22
to puppe...@googlegroups.com
Austin Blatt created an issue
 
PuppetDB / Epic PDB-5552
Improve the removal of old reports partitions
Issue Type: Epic Epic
Assignee: Unassigned
Created: 2022/10/20 1:56 PM
Priority: Normal Normal
Reporter: Austin Blatt

Remove partitions in a non-blocking (of command-processing and queries) manner.

Due to prior limitations in PG partitioning, a number of Access Exclusive locks are needed to remove partitions. These require waiting for all existing table usage to finish before the lock can be acquired. They also block all future queries and commands until they complete.
Add Comment Add Comment
 
This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8)
Atlassian logo

Austin Blatt (Jira)

unread,
Oct 20, 2022, 6:36:03 PM10/20/22
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Team/s: Skeletor

David Piekny (Jira)

unread,
Nov 18, 2022, 2:20:01 PM11/18/22
to puppe...@googlegroups.com
David Piekny updated an issue
Change By: David Piekny
Labels: Phase_1 enterprise-scalability

Lisa Ross (Jira)

unread,
Nov 28, 2022, 10:55:03 AM11/28/22
to puppe...@googlegroups.com
Lisa Ross updated an issue
Change By: Lisa Ross
Labels: 23Q1 Phase_1 enterprise-scalability

David Piekny (Jira)

unread,
Jan 24, 2023, 3:44:02 PM1/24/23
to puppe...@googlegroups.com
David Piekny updated an issue
Change By: David Piekny
Epic Colour: ghx-label- 5 2

David Piekny (Jira)

unread,
Feb 16, 2023, 4:50:03 PM2/16/23
to puppe...@googlegroups.com
David Piekny updated an issue
Change By: David Piekny
Fix Version/s: 2023.y

Jaleen Walker (Jira)

unread,
Apr 12, 2023, 2:26:03 PM4/12/23
to puppe...@googlegroups.com
Jaleen Walker updated an issue
Change By: Jaleen Walker
Epic Status: To Do Done

Austin Blatt (Jira)

unread,
Jun 1, 2023, 2:54:02 PM6/1/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Fix Version/s: 2023.y
This message was sent by Atlassian Jira (v8.20.21#820021-sha1:38274c8)
Atlassian logo
Reply all
Reply to author
Forward
0 new messages