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

the users_who_share_rooms table explodes in size O(N^2) #3849

Open
ara4n opened this issue Sep 12, 2018 · 1 comment
Open

the users_who_share_rooms table explodes in size O(N^2) #3849

ara4n opened this issue Sep 12, 2018 · 1 comment
Labels
A-Disk-Space things which fill up the disk O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.

Comments

@ara4n
Copy link
Member

ara4n commented Sep 12, 2018

matrix.org currently has 428643927 rows in it.
@erikjohnston
Copy link
Member

It is currently the 7th largest table on matrix.org by disk usage (including size of indices), and 7% the size of the largest table.

@neilisfragile neilisfragile added z-p2 (Deprecated Label) A-Disk-Space things which fill up the disk labels Oct 5, 2018
@reivilibre reivilibre added T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. S-Minor Blocks non-critical functionality, workarounds exist. O-Uncommon Most users are unlikely to come across this or unexpected workflow and removed z-p2 (Deprecated Label) labels May 23, 2023
@matrixbot matrixbot mentioned this issue Dec 21, 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-Disk-Space things which fill up the disk O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@neilisfragile @ara4n @erikjohnston @reivilibre