database size
-
Is it normal for the database to be half a gigabyte?
I have deleted all my executions several times but it doesn't seem to change anything. Also just set
export DB_SQLITE_VACUUM_ON_STARTUP=truein/app/data/env.sh, but after restarting it seems to take the same amount of space. When I runSELECT pg_size_pretty(pg_database_size('XXXXX'))it sayspg_size_pretty ---------------- 594 MB (1 row)Is there some data stuck in there that I can see and remove somehow?
-
That
DB_SQLITE_VACUUM_ON_STARTUPdoes nothing, is absolutly corret and is no error.
Because, the Cloudron package does not use SQLITE.
It uses postgresql. -
Is it normal for the database to be half a gigabyte?
I have deleted all my executions several times but it doesn't seem to change anything. Also just set
export DB_SQLITE_VACUUM_ON_STARTUP=truein/app/data/env.sh, but after restarting it seems to take the same amount of space. When I runSELECT pg_size_pretty(pg_database_size('XXXXX'))it sayspg_size_pretty ---------------- 594 MB (1 row)Is there some data stuck in there that I can see and remove somehow?
-
@rosano you should investigate which table is taking so much space . (you can get table size queries from chatgpt)
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login