deal with users table growing size

yewtudotbe / invidious-custom

Invidious with some git patches (mostly from existing PRs)

GNU Affero General Public License v3.0

211 stars 43 forks source link

deal with users table growing size #18

Closed unixfox closed 2 years ago

unixfox commented 2 years ago

https://medium.com/compass-true-north/dealing-with-significant-postgres-database-bloat-what-are-your-options-a6c1814a03a5
https://www.cybertec-postgresql.com/en/hot-updates-in-postgresql-for-better-performance/

unixfox commented 2 years ago

import the yewtu.be database to two servers where one is running the latest version of invidious and one is running a version before the database improvements.

unixfox commented 2 years ago

slow vacuum:

https://www.postgresql.org/docs/9.1/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST
https://www.postgresql.org/docs/9.5/config-setting.html

unixfox commented 2 years ago

may be fixed by https://github.com/iv-org/invidious/issues/2844