Postgres Pro
Downloads
Home   >   mailing lists

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

From Luca Ferrari
Subject drop table but file still exists
Date
Msg-id 200905150909.22914.fluca1978@infinito.it
Whole thread Raw
Responses Re: drop table but file still exists  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: drop table but file still exists  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Philipp Marek
Date:
Subject: Re: Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER
Next
From: "Massa, Harald Armin"
Date:
Subject: PostgreSQL service not starting / reattach shared memory - found some hints in logs..