Re: Load distributed checkpoint

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <Kgrittn(dot)CCAP(dot)Courts(at)wicourts(dot)gov>, "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Load distributed checkpoint
Date: 2006-12-08 18:18:58
Message-ID: 1165601938.10248.56.camel@dba5.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Fri, 2006-12-08 at 11:55 -0600, Kevin Grittner wrote:
> >>> On Fri, Dec 8, 2006 at 11:01 AM, in message
> <4579461A(dot)EE98(dot)0025(dot)0(at)wicourts(dot)gov>, "Kevin Grittner"
> <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>
> I'm going to correct a previous statement, based on having just chatted
> with a member of the web team.
>
> The remaining dribble of these was only occurring on the Windows
> machines. (We were running two servers from Windows and two from Linux
> for a while to see how things compared.) The settings I previously
> posted have completely eliminated the problem on Linux, and we are
> moving all servers to Linux, so this has become a total non-issue for
> us. I really encourage people to try some much more aggressive
> background writer settings, and possibly try tuning the OS dirty write
> settings.

How much increased I/O usage have you seen in regular operation with
those settings?

--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2006-12-08 18:30:09 Re: Load distributed checkpoint
Previous Message Tom Lane 2006-12-08 18:18:36 Re: [HACKERS] Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

Browse pgsql-patches by date

  From Date Subject
Next Message Kevin Grittner 2006-12-08 18:30:09 Re: Load distributed checkpoint
Previous Message Tom Lane 2006-12-08 18:18:36 Re: [HACKERS] Configuring BLCKSZ and XLOGSEGSZ (in 8.3)