Re: HOT patch - version 15

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: HOT patch - version 15
Дата
Msg-id Pine.GSO.4.64.0709070028390.3136@westnet.com
обсуждение исходный текст
Ответ на Re: HOT patch - version 15  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список pgsql-patches
On Thu, 6 Sep 2007, Heikki Linnakangas wrote:

> I wonder if pruning in bgwriter only is enough to make HOT work
> efficiently. On a very frequently updated page, bgwriter will have to
> work hard to keep up.

One of the goals for how I rebuilt the just-in-time BGW was to try and
make smaller values for bgwriter_delay feasible.  None of the tunables
*should* have to be adjusted if you need to run the bgwriter much more
often to support some new HOT-related activity in there as well; this is
actually my next area I wanted to do a bit more testing on myself.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: [BUGS] create index concurrently blocks on transactions in other databases
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: tsearch refactorings