How can I run a VACUUM FULL on my db?
Got an email saying I've used 100% of my 0.54 GB monthly storage allowance.
My dashboard says 0.29/0.5 GB used.
2 Replies
secure-lavender•3w ago
Hey!
The metrics that you see in the dashboard are the source of truth, so if your dashboard says you have 200MB left, then you can safely ignore the email.
As for running a vacuum full, you can just run
VACUUM FULL, or use the pg_repack extension to do it online with less locking : https://neon.com/docs/extensions/pg_repackNeon
The pg_repack extension - Neon Docs
Postgres, like any database system, can accumulate bloat over time due to frequent updates and deletes. Bloat refers to wasted space within your tables and indexes, which can lead to decreased query p...
multiple-amethystOP•3w ago
Thank you.