Re: 'Real' auto vacuum?

От: Mindaugas Riauba
Тема: Re: 'Real' auto vacuum?
Дата: ,
Msg-id: 00f601c5adeb$56fcb910$
(см: обсуждение, исходный текст)
Ответ на: '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.


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

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