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* ?
