JustTheSyme
11/30/2021, 9:32 PM"could not extend file \"base/12662/16813\": No space left on this device
when trying to insert to my database. I'm on using a 1/3 of the database's alloted space. What might be going on here?Scott P
11/30/2021, 9:34 PMJustTheSyme
11/30/2021, 9:44 PMScott P
11/30/2021, 10:01 PMVACUUM
from the SQL terminal on the dashboard. Essentially, each time you perform an update on a table, the original record is kept in the database and VACUUM
helps remove these dead references - More details: https://www.postgresql.org/docs/9.5/sql-vacuum.html
I'd even recommend running VACUUM ANALYZE
so that it updates stats on query executions.
VACUUM FULL
is more intensive, but will cause table locking and so should only be used if you're not expecting traffic.
If you only want to use it against a specific table, run VACUUM [table_name]
.
You can also run REINDEX INDEX [index_name]
if you've got indexes and this will recreate the index which might also clean them up and reduce space usage (and optimise performance at the same time) - More details: https://www.postgresql.org/docs/9.4/sql-reindex.htmlJustTheSyme
12/01/2021, 12:05 AM