Re: [PATCH] Unremovable tuple monitoring

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [PATCH] Unremovable tuple monitoring
Дата
Msg-id 1321370854-sup-9997@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: [PATCH] Unremovable tuple monitoring  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [PATCH] Unremovable tuple monitoring  (Greg Smith <greg@2ndQuadrant.com>)
Re: [PATCH] Unremovable tuple monitoring  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Excerpts from Robert Haas's message of mar nov 15 12:16:54 -0300 2011:
>
> On Tue, Nov 15, 2011 at 10:05 AM, Yeb Havinga <yebhavinga@gmail.com> wrote:
> > I reviewed your patch. I think it is in good shape, my two main remarks
> > (name of n_unremovable_tup and a remark about documentation at the end of
> > this review) are highly subjective and I wouldn't spend time on it unless
> > other people have the same opinion.
>
> I share your opinion; it's not obvious to me what this means either.
> I guess this is a dumb question, but why don't we remove all the dead
> tuples?

They were deleted but there are transactions with older snapshots.

I think vacuum uses the term "nondeletable" or "nonremovable".  Not sure
which one is less bad.  Not being a native speaker, they all sound
horrible to me.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: [PATCH] Unremovable tuple monitoring
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: ToDo: pg_backup - using a conditional DROP