Re: ignore_killed_tuples is always true

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Re: ignore_killed_tuples is always true
Дата
Msg-id 20060213111511.49B5.ITAGAKI.TAKAHIRO@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: ignore_killed_tuples is always true  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> It's not saving any noticeable amount of code, and what it is doing
> is removing functionality we might want someday.  It's not hard to
> imagine pgstattuple or VACUUM or other maintenance operations wanting
> to look at killed index entries.

I suggested it not for performance, but for simplicity of code. So if we
still need it, I agree to leave it.

Moreover, LP_DELETEed tuples might be useful for Bitmap NOT And/Or join,
not only maintenance operations. Union-side of bitmap should not contain
LP_DELETEed tuples, and Except-side should do.

---
ITAGAKI Takahiro
NTT Cyber Space Laboratories



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

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: [GENERAL] Number format problem
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: Free WAL caches on switching segments