pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Decibel! <decibel@decibel.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: PITR backup to Novell Netware file server
Date: Tue, 07 Aug 2007 19:38:47 -0500
Message-ID: <46B8CA47.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <20070807215139.GT25704@nasby.net>
References: <46B8114E.EE98.0025.0@wicourts.gov>
	<20070807182800.GJ25704@nasby.net>
	<46B87DCD.EE98.0025.0@wicourts.gov>
	<20070807215139.GT25704@nasby.net>

> >>> Decibel! <decibel@decibel.org> 08/07/07 4:51 PM >>> 
> On Tue, Aug 07, 2007 at 02:12:29PM -0500, Kevin Grittner wrote:
> > > Copying a 16MB file that's already in memory isn't exactly an intensive
> > > operation...
> >  
> > That's true for the WAL files.  The base backups are another story.  We will
> > normally have a database vacuum analyze between the base backup and the users
> > being in there to care about performance, but that's not always the case --
> > sometimes jury trials go late into the night and could overlap with this a
> > base backup.  And some judges put in a lot of late hours; although they don't
> > tend to bang on the database very heavily, they hate to be made to wait.
> 
> Ahh... well, that's something where rsync could actually help you since
> it allows you to put a bandwidth cap on it. Another option is that some
> OSes (FreeBSD for one) will respect process priority when it comes to
> scheduling IO as well, so if you nice the backup process it hopefully
> wouldn't impact the database as much.

Thanks for the suggestions.  A new OS is not in the cards any time soon, but
I think the --bwlimit option makes sense -- there's not a lot of point moving
it from the database server to the file server faster than the WAN can take it,
anyway.  I suppose I could "nice" the rsync requester on the database side, too.
 
-Kevin
 





view thread (8+ messages)  latest in thread

Message-ID: <46B8CA47.EE98.0025.0@wicourts.gov>
Permalink:  ../46B8CA47.EE98.0025.0@wicourts.gov/
Also on:    postgresql.org/message-id/46B8CA47.EE98.0025.0@wicourts.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, decibel@decibel.org
  Subject: Re: PITR backup to Novell Netware file server
  In-Reply-To: <46B8CA47.EE98.0025.0@wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox