Re: 'Real' auto vacuum?

От: Mindaugas Riauba
Тема: Re: 'Real' auto vacuum?
Дата: ,
Msg-id: 00f601c5adeb$56fcb910$f20214ac@bite.lt
(см: обсуждение, исходный текст)
Ответ на: 'Real' auto vacuum?  (Ralph Mason)
Ответы: Re: 'Real' auto vacuum?  (Brad Nicholson)
Список: pgsql-performance

Скрыть дерево обсуждения

'Real' auto vacuum?  (Ralph Mason, )
 Re: 'Real' auto vacuum?  (, )
  Re: 'Real' auto vacuum?  (Ralph Mason, )
 Re: 'Real' auto vacuum?  (Josh Berkus, )
 Re: 'Real' auto vacuum?  ("Mindaugas Riauba", )
  Re: 'Real' auto vacuum?  (Brad Nicholson, )

> > When a row is orphaned it's added to a list of possibly available rows.
> > When a new row is needed the list of possible rows is examined and the
> > first one with a transaction id less then the lowest running transaction
> > id is chosen to be the new row?  These rows can be in a heap so it's
> > really fast to find one.
>
> This is the long-term plan.    However, it's actually a lot harder than it
> sounds.  Patches welcome.

  Some ETA? Since that would be the most welcome addition for us. We
have few very heavily updated databases where table bloat and constant
vacuuming is killing performance.

  Mindaugas



В списке pgsql-performance по дате сообщения:

От: "Mindaugas Riauba"
Дата:
Сообщение: Re: 'Real' auto vacuum?
От: Brad Nicholson
Дата:
Сообщение: Re: 'Real' auto vacuum?