Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create separate background worker to analyze partition sets #514

Open
keithf4 opened this issue Mar 22, 2023 · 0 comments
Open

Create separate background worker to analyze partition sets #514

keithf4 opened this issue Mar 22, 2023 · 0 comments

Comments

@keithf4
Copy link
Collaborator

keithf4 commented Mar 22, 2023

PostgreSQL still does not have a means to automatically analyze a partition set from the parent level. Distinct statistics are gathered when this is done for optimized partition querying.

Currently the maintenance procedure has an option to analyze the partition sets as part of that maintenance, but this was disabled being on by default due to causing long maintenance run times which in turn cause locking issues.

Create a separate background worker that is explicitly for running analyze at the parent level. Can use the existing run_analyze() function

@keithf4 keithf4 added this to the Future milestone Mar 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant