On Fri, 2009-05-15 at 09:09 +0200, Luca Ferrari wrote:
> 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?
To avoid various problems the files are removed after the next
checkpoint.
--
Si
Luca Ferrari 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.
Hi,
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?
Thanks,
Luca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postg