Re: How are files of tables/indexes/etc deleting? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: How are files of tables/indexes/etc deleting?
Date
Msg-id A737B7A37273E048B164557ADEF4A58B53841A5B@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to How are files of tables/indexes/etc deleting?  (Иван Фролков <ifrol2001@mail.ru>)
List pgsql-general
Иван Фролков wrote:
> When I drop a table, the file which contains real data will be deleted, but only when I will commit
> transaction. It seems like such job must do vacuum, but I cannot locate the code which does the real
> job. Could anybody explain in details how it works?

See RelationDropStorage() in src/backend/catalog/storage.c

No vacuum is necessary, the files that belong to the relation are deleted at commit time.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Vacuum never completed....
Next
From: Tom Lane
Date:
Subject: Re: error while installing auto_explain contrib module