Re: odd output in restore mode

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: odd output in restore mode
Date: 2008-05-18 12:38:12
Message-ID: 48302334.2020906@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Dave Page wrote:
> On Tue, May 13, 2008 at 5:11 PM, Alvaro Herrera
> <alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2008-05-18 13:33:27 Re: libpq object hooks (libpq events)
Previous Message Tatsuo Ishii 2008-05-18 11:51:29 WITH RECURSIVE patch V0.1

Browse pgsql-patches by date

  From Date Subject
Next Message Merlin Moncure 2008-05-18 13:33:27 Re: libpq object hooks (libpq events)
Previous Message Tatsuo Ishii 2008-05-18 11:51:29 WITH RECURSIVE patch V0.1