RE: [HACKERS] mdnblocks is an amazing time sink in huge relations

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: [HACKERS] mdnblocks is an amazing time sink in huge relations
Дата
Msg-id 000701bf1a16$8e4ee100$2801007e@cadzone.tpf.co.jp
обсуждение исходный текст
Ответ на Re: [HACKERS] mdnblocks is an amazing time sink in huge relations  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> 
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:

[snip]
> 
> > Deletion is necessary only not to consume disk space.
> >
> > For example vacuum could remove not deleted files.
> 
> Hmm ... interesting idea ... but I can hear the complaints
> from users already...
>

My idea is only an analogy of PostgreSQL's simple recovery
mechanism of tuples.

And my main point is"delete fails after commit" doesn't harm the databaseexcept that not deleted files consume disk
space.

Of cource,it's preferable to delete relation files immediately
after(or just when) commit.
Useless files are visible though useless tuples are invisible.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] funny psql output
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] mdnblocks is an amazing time sink in huge relations