pg.ddx.io  pgsql-patches@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: Dave Page <dpage@pgadmin.org>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: odd output in restore mode
Date: Sun, 18 May 2008 08:38:12 -0400
Message-ID: <48302334.2020906@dunslane.net> (raw)
In-Reply-To: <937d27e10805130915n7fa68737ka573d43b516f7bc0@mail.gmail.com>
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>



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



view thread (59+ messages)  latest in thread

Message-ID: <48302334.2020906@dunslane.net>
Permalink:  ../48302334.2020906@dunslane.net/
Also on:    postgresql.org/message-id/48302334.2020906@dunslane.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-patches@postgresql.org
  Cc: andrew@dunslane.net, dpage@pgadmin.org, alvherre@commandprompt.com, simon@2ndquadrant.com, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org
  Subject: Re: odd output in restore mode
  In-Reply-To: <48302334.2020906@dunslane.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox