Re: How are files of tables/indexes/etc deleting?

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: How are files of tables/indexes/etc deleting?
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B53841A5B@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на How are files of tables/indexes/etc deleting?  (Иван Фролков <ifrol2001@mail.ru>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Vacuum never completed....
Следующее
От: Tom Lane
Дата:
Сообщение: Re: error while installing auto_explain contrib module