Re: Recalculating OldestXmin in a long-running vacuum

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Recalculating OldestXmin in a long-running vacuum
Дата
Msg-id 200703271715.l2RHFhC07074@momjian.us
обсуждение исходный текст
Ответ на Re: Recalculating OldestXmin in a long-running vacuum  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-patches
Heikki Linnakangas wrote:
> Tom Lane wrote:
> > Heikki Linnakangas <heikki@enterprisedb.com> writes:
> >> Bruce Momjian wrote:
> >>> So are you stopping work on the patch?  I assume so.
> >
> >> Yes, at least for now. I can't believe the patch actually hurts
> >> performance, but I'm not going to spend time investigating it.
> >
> > Are we withdrawing the patch from consideration for 8.3 then?
> > I had assumed it was still a live candidate, but if it seems to
> > lose in pgbench maybe we had better set it aside.
>
> I haven't tried pgbench, the tests I ran were with DBT-2.
>
> Just to summarize again: the patch did help to keep the stock table
> smaller, but the response times were higher with the patch.
>
> Maybe we should keep this issue open until we resolve the vacuum WAL
> flush issue? I can then rerun the same tests to see if this patch is a
> win after that.

Would you like to add a TODO item?

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Recalculating OldestXmin in a long-running vacuum
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Recalculating OldestXmin in a long-running vacuum