Re: Load distributed checkpoint V3

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Load distributed checkpoint V3
Дата
Msg-id Pine.GSO.4.64.0703251124070.24552@westnet.com
обсуждение исходный текст
Ответ на Load distributed checkpoint V3  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Ответы Re: Load distributed checkpoint V3  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список pgsql-patches
On Fri, 23 Mar 2007, ITAGAKI Takahiro wrote:

> Here is the latest version of Load distributed checkpoint patch.

Couple of questions for you:

-Is it still possible to get the original behavior by adjusting your
tunables?  It would be nice to do a before/after without having to
recompile, and I know I'd be concerned about something so different
becoming the new default behavior.

-Can you suggest a current test case to demonstrate the performance
improvement here?  I've tried several variations on stretching out
checkpoints like you're doing here and they all made slow checkpoint
issues even worse on my Linux system.  I'm trying to evaluate this fairly.

-This code operates on the assumption you have a good value for the
checkpoint timeout.  Have you tested its behavior when checkpoints are
being triggered by checkpoint_segments being reached instead?

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

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Load distributed checkpoint V3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Improvement of procArray.xmin for VACUUM