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.

Sign up for GitHub

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

Jump to bottom

Use partitioned scoped events/state PostgreSQL tables #3776

Closed

olivergrabinski opened this issue Mar 29, 2023 · 0 comments · Fixed by #3787

Labels

delta enhancement

Contributor

olivergrabinski commented Mar 29, 2023

Motivation
In order to make project level queries faster, the scoped events/state tables can be partitioned by project.
Changes needed:

Update tables schemas to allow partitions
When creating a project, a "companion" partition for the project is created for both scoped events and states.

Side-effects:

It is possible to export the events/states of a project by exporting its partition.
Project deletion boils down to the deletion of its partition.

Acceptance criteria

When a project is created, it has a corresponding partition for its scoped events.
When a project is created, it has a corresponding partition for its scoped states.

API changes
None

Not in scope

When a project is deleted, its partition should also be deleted.

olivergrabinski added enhancement delta labels

olivergrabinski mentioned this issue

Add table partitioning for scoped events/states #3787

Merged

olivergrabinski closed this as completed in #3787

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment