Skip to content

High DB usage on pusher processes #19697

@richvdh

Description

@richvdh

Sometimes our pusher workers spend a period of time hammering the database via get_unread_counts_by_room_for_user.

I believe #16756 was an attempt to improve it, but that got reverted in #16979.

Per matrix-org/matrix-spec-proposals#4076, we should give apps a way to opt-out of receiving the badge counts, because it's usually wrong and isn't necessary.

Per matrix-org/matrix-spec#644, what we return isn't correct according to the spec, anyway.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions