Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 27ECF650411
	for <pgsql-patches-postgresql.org@postgresql.org>;
	Sun, 27 Jul 2008 22:19:55 -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 32740-01-10 for
	<pgsql-patches-postgresql.org@postgresql.org>;
	Sun, 27 Jul 2008 22:19:44 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from alexis.jtlnet.com (alexis.jtlnet.com [69.36.9.81])
	by postgresql.org (Postfix) with ESMTP id 7567864FCB9
	for <pgsql-patches@postgresql.org>;
	Sun, 27 Jul 2008 20:42:27 -0300 (ADT)
Received: from [192.168.10.103] (cpe-075-177-154-079.nc.res.rr.com
	[::ffff:75.177.154.79]) (TLS: TLSv1/SSLv3,256bits,AES256-SHA)
	by alexis.jtlnet.com with esmtp; Sun, 27 Jul 2008 19:36:05 -0400
	id 0008BBEF.488D0665.00006D8F
Message-ID: <488D07E0.4020303@dunslane.net>
Date: Sun, 27 Jul 2008 19:42:24 -0400
From: Andrew Dunstan <andrew@dunslane.net>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.8.0.12) Gecko/20071019 Fedora/1.0.9-3.fc6 pango-text
	SeaMonkey/1.0.9
MIME-Version: 1.0
To: "Joshua D. Drake" <jd@commandprompt.com>
CC: Simon Riggs <simon@2ndquadrant.com>,
	Tom Lane <tgl@sss.pgh.pa.us>, Stephen Frost <sfrost@snowman.net>,
	pgsql-patches@postgresql.org
Subject: Re: pg_dump additional options for performance
References: <20080721115602.GG18846@tamriel.snowman.net>	
	<1216831237.3894.676.camel@ebony.2ndQuadrant>	
	<1216832987.3894.678.camel@ebony.2ndQuadrant>	
	<20080724032047.GI18846@tamriel.snowman.net>	
	<1216885031.3894.739.camel@ebony.2ndQuadrant>	
	<21687.1216886041@sss.pgh.pa.us>	
	<1216889809.3894.747.camel@ebony.2ndQuadrant>	
	<2818.1217027784@sss.pgh.pa.us>	
	<1217063104.3894.1100.camel@ebony.2ndQuadrant>	
	<23540.1217089204@sss.pgh.pa.us>	
	<20080726164355.GH16005@tamriel.snowman.net>	
	<24327.1217094186@sss.pgh.pa.us>
	<1217095404.16378.184.camel@jd-laptop>
	<1217151454.3894.1225.camel@ebony.2ndQuadrant>
	<488CA8ED.6080908@commandprompt.com>
In-Reply-To: <488CA8ED.6080908@commandprompt.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200807/267
X-Sequence-Number: 6961



Joshua D. Drake wrote:
>
> Agreed but that is a problem I understand with a solution I don't. I 
> am all eyes on a way to fix that. One thought I had and please, be 
> gentle in response was some sort of async transaction capability. I 
> know that libpq has the ability to send async queries. Is it possible 
> to do this:
>
> send async(copy table to foo)
> send async(copy table to bar)
> send async(copy table to baz)
>
> Where all three copies are happening in the background?
>
>

IIRC, libpq doesn't let you have more than one async query active at one 
time.

cheers

andrew