Émilien (perso)

Results 898 comments of Émilien (perso)

I just created a Docker image of [Huginn single process](https://github.com/huginn/huginn/tree/master/docker/single-process) compatible with ARMv7/armhf, ARMv8/aarch64 and intel x86. This image is automatically updated for every new commit on https://github.com/huginn/huginn. You can...

> Happened again You need to do `VACUUM FULL users;` like explained on Matrix.

We could schedule a periodic VACUUM with https://github.com/citusdata/pg_cron.

Or just use crystal job system, that's simpler.

> PostgreSQL supports automatic vacuum already [postgresql.org/docs/10/routine-vacuuming.html#AUTOVACUUM](https://www.postgresql.org/docs/10/routine-vacuuming.html#AUTOVACUUM) It should be enabled by default AUTOVACUUM != VACUUM FULL a vacuum full literally freeze/lock the table while doing its thing, that's not...

> I'm running into this as well on my instance (invidious.sethforprivacy.com), but it's filling the disk in ~1h ATM for some reason. > > In 1h20m, my `users` table went...

Could all of you try the latest Docker image in order to confirm that it solves the issue?

`quay.io/invidious/invidious:latest` is to be tested

> Testing latest version. > > The subscription page appears to be working, watch notifications is resetting back to zero and its pulled some updates from today although it missed...

I'm now running this command every 10 minutes in order to force a soft vacuum that doesn't lock the tables: `VACUUM FREEZE users;`. It won't reclaim the disk space used...