Re: Patch to remove/report orphaned files

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Patch to remove/report orphaned files
Дата
Msg-id 4405.990769076@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Patch to remove/report orphaned files  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Patch to remove/report orphaned files  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> This patch removes old sort files on postmaster startup, and reports
> orphaned database directory files during database vacuum.

I like the first part, but not the second.  To name just one problem,
it will go berserk after OID wraparound.  The "minimum startup OID"
approach would be ugly even if it weren't fundamentally broken.
That O(N^2) search will get a tad tedious with a lot of tables, too.

I really don't think we have a problem that needs fixing in this area;
surely not a problem bad enough to justify a band-aid as ugly as this.

            regards, tom lane

В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Patch to remove/report orphaned files
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Patch to remove/report orphaned files