Horton

Re: Allowing multiple concurrent base backups

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: David Fetter <david@fetter.org>
Cc: marcin mank <marcin.mank@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Magnus Hagander <magnus@hagander.net>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-01-12T15:17:38Z
Lists: pgsql-hackers 
On 12.01.2011 17:15, David Fetter wrote:
> On Wed, Jan 12, 2011 at 10:26:05AM +0100, marcin mank wrote:
>> Considering that parallell base backups would be io-bound (or
>> network-bound), there is little need to actually run them in parallell
>
> That's not actually true.  Backups at the moment are CPU-bound, and
> running them in parallel is one way to make them closer to I/O-bound,
> which is what they *should* be.

That's a different kind of "parallel". We're talking about taking 
multiple backups in parallel, each using one process, and you're talking 
about taking one backup using multiple parallel processes or threads.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com