Re: 'Real' auto vacuum?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: 'Real' auto vacuum?
Дата
Msg-id 200508301558.34697.josh@agliodbs.com
обсуждение исходный текст
Ответ на 'Real' auto vacuum?  (Ralph Mason <ralph.mason@telogis.com>)
Список pgsql-performance
Ralph,

> 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.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: mark@mark.mielke.cc
Дата:
Сообщение: Re: 'Real' auto vacuum?
Следующее
От: Ron
Дата:
Сообщение: Re: RAID Configuration Sugestion