Jira (PDB-4899) Update docs for report_ttl and resource_events

Zachary Kent (Jira)

unread,

Sep 18, 2020, 11:59:04 AM9/18/20

to puppe...@googlegroups.com

Zachary Kent updated an issue

PuppetDB /

PDB-4899

Update docs for report_ttl and resource_events_ttl

Change By:	Zachary Kent
Labels:	docs

Add Comment

This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935)

Zachary Kent (Jira)

unread,

Sep 18, 2020, 11:59:06 AM9/18/20

to puppe...@googlegroups.com

Zachary Kent created an issue

PuppetDB /

PDB-4899

Update docs for report_ttl and resource_events_ttl

Issue Type:	New Feature
Assignee:	Unassigned
Created:	2020/09/18 8:58 AM
Priority:	Normal
Reporter:	Zachary Kent

With the partitioning that was added for reports and resource_events if a user sets their report_ttl or resource_events_ttl to less than 1 day gc will try to drop a partition for the same day that incoming commands are creating. This will lead to churn and deadlocks in PG. We should update our documentation for the report_ttl and resource_events_ttl settings to reflect this issue.

Add Comment

Zachary Kent (Jira)

unread,

Sep 18, 2020, 12:00:04 PM9/18/20

to puppe...@googlegroups.com

Zachary Kent updated an issue

PuppetDB /

PDB-4899

Update docs for report_ttl and resource_events_ttl

Change By:	Zachary Kent
Epic Link:	PDB-4759

Add Comment

Tim Meusel (Jira)

unread,

Sep 18, 2020, 12:20:04 PM9/18/20

to puppe...@googlegroups.com

Tim Meusel commented on

PDB-4899

Re: Update docs for report_ttl and resource_events_ttl

Hi!
I just saw this on the mailing list. Did I understand it correctly that partitioning for the reports was introduced recently? I scrolled through the changelog and couldn't spot a hint. In which version was it introduced and if I have a huge amount of reports, might an upgrade cause a long downtime due to table migrations? (not sure if existing data will be split into partitions as well). Maybe infos to those questions can be added to the docs as well