Message-ID: <48302334.2020906@dunslane.net>
Date: Sun, 18 May 2008 08:38:12 -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: Dave Page <dpage@pgadmin.org>
CC: Alvaro Herrera <alvherre@commandprompt.com>,
	Simon Riggs <simon@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: odd output in restore mode
References: <4828CB9D.7070102@dunslane.net> <4828EBCB.6010004@dunslane.net>	
	<6489.1210642738@sss.pgh.pa.us>	
	<937d27e10805130042m35584e2fk79dc3490173d3bd4@mail.gmail.com>	
	<1210667576.29684.283.camel@ebony.site>	
	<482982DD.6060901@dunslane.net> <482988FB.5070307@dunslane.net>	
	<20080513150852.GD6966@alvh.no-ip.org>
	<4829BC66.4020602@dunslane.net>	
	<20080513161130.GJ6966@alvh.no-ip.org>
	<937d27e10805130915n7fa68737ka573d43b516f7bc0@mail.gmail.com>
In-Reply-To: <937d27e10805130915n7fa68737ka573d43b516f7bc0@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Dave Page wrote:
> On Tue, May 13, 2008 at 5:11 PM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:
>   
>> Andrew Dunstan wrote:
>>
>>  > I would be very surprised if xcopy did not exhibit the same
>>  > preallocating behaviour as copy.
>>
>>  I, on the other hand, would not say anything until someone tried it, and
>>  then wouldn't be surprised if it behaved either way :-)
>>     
>
> It pre-allocates the space as copy does. And yes, I did test :-p
>
>
>   

Dave,

I don't know how you tested, but could you please repeat the test with 
GnuWin32's cp.exe? If it doesn't preallocate the space then I think our 
way forward is reasonably clear:

. we recommend its use for Windows archive_command settings
. we provide the delay kluge as switchable behaviour on Windows instead 
of having it always on.

cheers

andrew