Re: drop table but file still exists - Mailing list pgsql-general

From Tom Lane
Subject Re: drop table but file still exists
Date
Msg-id 2727.1242396841@sss.pgh.pa.us
Whole thread Raw
In response to drop table but file still exists  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-general
Luca Ferrari <fluca1978@infinito.it> writes:
> I'm just curious to know why after a drop table the disk file is emptied but
> still existent. What is the reason why the file is not deleted immediately?

It's protecting against some obscure race condition involving
reassignment of the relfilenode number to a new table.  I forget the
details but you could troll the archives for it if you really care
--- I think we put that in about two or so years ago.

            regards, tom lane

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: how do you get there from here?
Next
From: Simon Riggs
Date:
Subject: Re: drop table but file still exists