Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 94C53650136
	for <pgsql-general-postgresql.org@postgresql.org>;
	Sat, 19 Jul 2008 05:56:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 52132-08 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Sat, 19 Jul 2008 05:56:26 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mk-outboundfilter-4.mail.uk.tiscali.com
	(mk-outboundfilter-4.mail.uk.tiscali.com [212.74.114.32])
	by postgresql.org (Postfix) with ESMTP id 0223D650129
	for <pgsql-general@postgresql.org>;
	Sat, 19 Jul 2008 05:56:28 -0300 (ADT)
X-Trace: 
 113273459/mk-outboundfilter-2.mail.uk.tiscali.com/F2S/$F2S-NILDRAM-ACCEPTED/f2s-temporary-group/85.211.229.155
X-SBRS: None
X-RemoteIP: 85.211.229.155
X-IP-MAIL-FROM: simon@2ndquadrant.com
X-IP-BHB: Once
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: ArUAAHdJgUhV0+Wb/2dsb2JhbAAIrjs
X-IronPort-AV: E=Sophos;i="4.31,214,1215385200"; d="scan'208";a="113273459"
X-IP-Direction: IN
Received: from 85-211-229-155.dyn.gotadsl.co.uk (HELO [192.168.0.3])
	([85.211.229.155])
	by smtp.f2s.tiscali.co.uk with ESMTP; 19 Jul 2008 09:56:25 +0100
Subject: Re: Backup/Restore of single table in multi TB database
From: Simon Riggs <simon@2ndquadrant.com>
To: Francisco Reyes <lists@stringsutils.com>
Cc: John Smith <sodgodofall@gmail.com>, pgsql-general@postgresql.org
In-Reply-To: <4881348E.3050002@stringsutils.com>
References: <b88f0d670805071302h469141e0ke29413edddb444e0@mail.gmail.com>
	<1210195724.4268.231.camel@ebony.site>
	<4881348E.3050002@stringsutils.com>
Content-Type: text/plain
Date: Sat, 19 Jul 2008 10:02:32 +0100
Message-Id: <1216458152.19656.799.camel@ebony.2ndQuadrant>
Mime-Version: 1.0
X-Mailer: Evolution 2.12.0 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL=0.007
X-Spam-Level: 
X-Archive-Number: 200807/714
X-Sequence-Number: 135293


On Fri, 2008-07-18 at 20:25 -0400, Francisco Reyes wrote:

> Does pg_snapclone works mostly on large rows or will it also be faster 
> than pg_dump for narrow tables?

It allows you to run your dump in multiple pieces. Thats got nothing to
do with narrow or wide.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support