Re: drop table but file still exists

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Luca Ferrari <fluca1978(at)infinito(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: drop table but file still exists
Date: 2009-05-15 14:17:54
Message-ID: 1242397074.3843.759.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message wickro 2009-05-15 16:13:38 Re: work_mem greater than 2GB issue
Previous Message Tom Lane 2009-05-15 14:14:01 Re: drop table but file still exists