JustTheSyme11/30/2021, 9:32 PM
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?
"could not extend file \"base/12662/16813\": No space left on this device
Scott P11/30/2021, 9:34 PM
JustTheSyme11/30/2021, 9:44 PM
Scott P11/30/2021, 10:01 PM
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
helps remove these dead references - More details: https://www.postgresql.org/docs/9.5/sql-vacuum.html I'd even recommend running
so that it updates stats on query executions.
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
. You can also run
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.html
REINDEX INDEX [index_name]
JustTheSyme12/01/2021, 12:05 AM