Running `vacuum full` understandably takes some ti...
# help
d
Running
vacuum full
understandably takes some time but running the command from the SQL editor returns
An error has occured: Failed to fetch
. I'm guessing the connection times out since the query takes some time to run. But I would like to know whether the query finished running or not. I think it's getting terminated since the dead tuples are not getting removed.
n
Hello @debabrata! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the
/title
command! We have solved your problem? Click the button below to archive it.
d
Currently, the
pg_class
table has 350k+ dead tuples and they are taking up quite a lot of space. So I would like to remove them somehow
On checking the logs, I can find this error message:
SQL Error [58P01]: ERROR: could not write to file "pg_logical/mappings/map-3176-4eb-0_99C8FB88-1ab1-ddb4", wrote -1 of 72: No such file or directory