search

python-discord / infra

Infrastructure for Python Discord
https://docs.pydis.wtf
MIT License
12 stars 4 forks source link

Deploy pg_repack #544

Open ChrisLovering opened 1 week ago

ChrisLovering commented 1 week ago

pg_repack is a great tool for removing table bloat.

Debian has postgresql-15-repack available on apt. We should install this and ensure the extension exists on all databases defined in the postgres role (CREATE EXTENSION pg_repack).

jchristgit commented 1 week ago

What would instalign and ensuring the extension exists do? Do we want to schedule a periodic repack or are we just preparing for when we might need it?

ChrisLovering commented 1 week ago

Yeah I thought about adding a cron for it, but wasn't sure. Maybe we could jsut do one weekly?