Skip to content
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was 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

@reivilibre

Description

@reivilibre

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-DatabaseDB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the dbA-Disk-Spacethings which fill up the diskS-MinorBlocks non-critical functionality, workarounds exist.S-TolerableMinor significance, cosmetic issues, low or no impact to users.T-EnhancementNew features, changes in functionality, improvements in performance, or user-facing enhancements.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions