Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Date: 2007-09-27 11:56:51
Message-ID: 1190894211.4194.64.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2007-09-26 at 16:31 -0500, Kevin Grittner wrote:

> The one downside I've found is that it adds 0.2
> seconds of CPU time per WAL file archive during our heaviest update
> periods. It's in the archiver process, not a backend process that's
> running a query, and we're not generally CPU bound, so this is not a
> problem for us.

OK, first time anybody's measured a significant cost to process creation
during execution of the archive_command. Still fairly low though.

Increasing the size of the WAL files would cure that. :-(

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brendan Jurd 2007-09-27 12:53:06 Re: Eliminate more detoast copies for packed varlenas
Previous Message Simon Riggs 2007-09-27 11:08:40 Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)