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

Add --analyze mode #9

Open
jberkus opened this issue Oct 21, 2014 · 1 comment
Open

Add --analyze mode #9

jberkus opened this issue Oct 21, 2014 · 1 comment

Comments

@jberkus
Copy link
Contributor

jberkus commented Oct 21, 2014

Add --analyze mode to analyze only certain tables which otherwise might not get analyzed promptly, such as very large append-only tables, or very small tables. Would work on a simple time-limit basis.

@qdw
Copy link
Contributor

qdw commented Oct 26, 2018

Seems like it would be just as easy to do a cron job that runs analyzedb on specific tables, unless there's supposed to be some intelligence here that can know when a table is, .e.g., append-only (perhaps by consulting pg_stat_user_tables?)

Overall, this feature seems easy to supplant with human knowledge about the DB.

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

2 participants