Re: Load distributed checkpoint V3 - Mailing list pgsql-patches

From Greg Smith
Subject Re: Load distributed checkpoint V3
Date
Msg-id Pine.GSO.4.64.0703251124070.24552@westnet.com
Whole thread Raw
In response to Load distributed checkpoint V3  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Load distributed checkpoint V3
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Load distributed checkpoint V3
Next
From: Tom Lane
Date:
Subject: Re: Improvement of procArray.xmin for VACUUM