Home > mailing lists

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

From	Simon Riggs
Subject	Re: drop table but file still exists
Date	May 15, 2009 14:19:55
Msg-id	1242397074.3843.759.camel@ebony.2ndQuadrant Whole thread Raw
In response to	drop table but file still exists (Luca Ferrari <fluca1978@infinito.it>)
List	pgsql-general

Tree view

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.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support

pgsql-general by date:

From: Tom Lane
Date: 15 May 2009, 14:15:30
Subject: Re: drop table but file still exists

From: "Arnold, Sandra"
Date: 15 May 2009, 16:30:11
Subject: Error in pgAdminIII

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

Previous

Next