Horton

Re: WIP patch for parallel pg_dump

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: marcin mank <marcin.mank@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Greg Smith <greg@2ndquadrant.com>, Joachim Wieland <joe@mcknight.de>, Andrew Dunstan <andrew@dunslane.net>, Robert Haas <robertmhaas@gmail.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-12-06T21:06:36Z
Lists: pgsql-hackers 
On 06.12.2010 21:48, marcin mank wrote:
> On Sun, Dec 5, 2010 at 7:28 PM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>> IIRC, in old discussions of this problem we first considered allowing
>> clients to pull down an explicit representation of their snapshot (which
>> actually is an existing feature now, txid_current_snapshot()) and then
>> upload that again to become the active snapshot in another connection.
>
> Could a hot standby use such a snapshot representation? I.e. same
> snapshot on the master and the standby?

Hmm, I suppose it could. That's an interesting idea, you could run 
parallel pg_dump or something else against master and/or multiple hot 
standby servers, all working on the same snapshot.

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