I was an unfortunate sequence of commands (all in single transaction)
DROP TABLE huge;
CREATE TABLE huge AS... (huge PostGIS ST_Union operation);
CREATE INDEX ON huge USING GIST (geometry);
by a well-meaning user, that caused a crash+recovery:
server process (PID 92411) was terminated by signal 9: Killed
terminating any other active server processes
all server processes terminated; reinitializing
database system was not properly shut down; automatic recovery in progress
And that left behind 280GB of files (of TABLE huge):
data/base/16384/2403959
...
data/base/16384/2403959.282
SELECT pg_filenode_relation(0,2403959);
-- returns NULL
may I do
sudo rm data/base/2403959*
?