postgresql - how to reclaim FS space from killed queries

eantoranz · 05-09-2013, 10:32 AM

Hi!

I noticed today that there were some queries left running since yesterday and they were eating up a lot of FS room on the server (probable queries with missing joins or ='s). I killed the processes with pg_cancel_backend but I don't see that the room on the FS has increased (I ran vacuum analyze verbose just in case but it made no difference). What do I have to do to reclaim this space?

Thanks in advance.

eantoranz · 05-09-2013, 11:13 AM

From reading http://www.postgresql.org/message-id/00a801ce03cf$8e9c61d0$abd52570$@com I restarted but space is not released yet.