Re: [GENERAL] drop table but file still exists

2009-05-15 Thread Simon Riggs
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

Re: [GENERAL] drop table but file still exists

2009-05-15 Thread Tom Lane
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.

[GENERAL] drop table but file still exists

2009-05-15 Thread Luca Ferrari
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