a vacuum thread is not the answer

Поиск
Список
Период
Сортировка
От mlw
Тема a vacuum thread is not the answer
Дата
Msg-id 3C87841F.3E580961@mohawksoft.com
обсуждение исходный текст
Ответы Re: a vacuum thread is not the answer  (Jan Wieck <janwieck@yahoo.com>)
Re: a vacuum thread is not the answer  (Hannu Krosing <hannu@krosing.net>)
Список pgsql-hackers
I was just toying around with things, and you know, running vacuum in the
background doesn't work. It slows things down too much.

The worst case senario is when one does this:

update accounts set abalance = abalance + 1 ;

This takes forever to run and doubles the size of the table.

Is there a way that a separate thread managing the freelist can perform a "per
row" vacuum concurrently? Maybe I am stating the problem incorrectly, but we
need to be able to recover rows already in memory for performance.


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

Предыдущее
От: Fernando Nasser
Дата:
Сообщение: Current cvs source regression: create_function_1.out
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Bad Build