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

Support for storing event resources and other resources in separate tables #601

Open
calvin0327 opened this issue Nov 27, 2023 · 1 comment · May be fixed by #647
Open

Support for storing event resources and other resources in separate tables #601

calvin0327 opened this issue Nov 27, 2023 · 1 comment · May be fixed by #647
Labels
kind/feature New feature

Comments

@calvin0327
Copy link

calvin0327 commented Nov 27, 2023

What would you like to be added?

Currently, we store all data in a single database table 'resource', which satisfies most scenarios. Event is a special resource in k8s, and its quantity is very large in general. If we put it in another table, we can handle it more conveniently and flexibly.

Why is this needed?

We have two main requirements to query the event resource:

  1. We will use the field LastTimestamp of evnet to sort, but the data for this field is in the json data, so we cannot use the general clusterpedia query method.

  2. As the number of clusters grows, the amount of event data is very large. Putting all the data in one table will cause query pressure on the database.

@calvin0327 calvin0327 added the kind/feature New feature label Nov 27, 2023
@clusterpedia-bot
Copy link

Hi @calvin0327,
Thanks for opening an issue!
We will look into it as soon as possible.

Details

Instructions for interacting with me using comments are available here.
If you have questions or suggestions related to my behavior, please file an issue against the gh-ci-bot repository.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/feature New feature
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants