Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

The cache_invalidation_stream_by_instance table is filled even when workers are not in use #15869

Open
reivilibre opened this issue Jul 3, 2023 · 0 comments
Open

The cache_invalidation_stream_by_instance table is filled even when workers are not in use #15869

reivilibre opened this issue Jul 3, 2023 · 0 comments
Labels
A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Disk-Space things which fill up the disk S-Minor Blocks non-critical functionality, workarounds exist. S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.

Comments

@reivilibre
Copy link
Contributor

The only precondition to having this table filled with cache invalidations is that the database engine is Postgres.

If we were interested, we could cut this down so this table is not populated when you're not using workers. (I'm not sure if we have such a flag available to be honest, but we can consider it if this is important to us!)

The benefit would be a small reduction in database I/O and CPU use for Postgres monoliths.

Related: #15868 which cleans up old rows in this table.
@reivilibre reivilibre added A-Disk-Space things which fill up the disk S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements. A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db labels Jul 3, 2023
@H-Shay H-Shay added the S-Minor Blocks non-critical functionality, workarounds exist. label Jul 5, 2023
@matrixbot matrixbot mentioned this issue Dec 22, 2023
Open
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Disk-Space things which fill up the disk S-Minor Blocks non-critical functionality, workarounds exist. S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@H-Shay @reivilibre