|From:||Simon Riggs <simon(at)2ndquadrant(dot)com>|
|To:||Andrew Dunstan <andrew(at)dunslane(dot)net>|
|Cc:||Bruce Momjian <bruce(at)momjian(dot)us>, Dave Page <dpage(at)pgadmin(dot)org>, List pgsql-patches <pgsql-patches(at)postgresql(dot)org>|
|Subject:||Re: [HACKERS] odd output in restore mode|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
On Mon, 2008-06-30 at 19:29 -0400, Andrew Dunstan wrote:
> Bruce Momjian wrote:
> > Dave Page wrote:
> >> On Sun, May 18, 2008 at 1:38 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> >>> I don't know how you tested,
> >> Copy a large file across a relatively slow network, and check the size
> >> on the destination drive before it finishes.
> >>> 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:
> >> It does not pre-allocate.
> >>> . 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.
> >> Sounds reasonable to me.
> > Are there any changes we need to make here?
> Yes. Simon has promised a patch to do the above.
* recommendation to use GnuWin32 cp on Windows
* provide "holdtime" delay, default 0 (on all platforms)
* default stays same on Windows="copy" to ensure people upgrading don't
Patch should be backpatched to 8.3, plus to CVS HEAD.
We should recommend in next 8.3 release notes that people use "-p" or
"-l" rather than just letting it default.
Will add permalink to Wiki when patch appears in archives.
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
|Next Message||Gregory Stark||2008-07-01 09:11:09||Re: Planned obsolescence in identify_system_timezone()|
|Previous Message||Richard Huxton||2008-07-01 07:45:44||Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump)|
|Next Message||Heikki Linnakangas||2008-07-01 10:33:24||Re: extend VacAttrStats to allow stavalues of different types|
|Previous Message||Simon Riggs||2008-07-01 07:41:34||Re: VACUUM Improvements - WIP Patch|