From: | Garick Hamlin <ghamlin(at)isc(dot)upenn(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Florian Pflug <fgp(at)phlo(dot)org>, Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Streaming base backups |
Date: | 2011-01-11 18:26:38 |
Message-ID: | 20110111182638.GB15361@isc.upenn.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Jan 11, 2011 at 12:45:02PM -0500, Tom Lane wrote:
> Florian Pflug <fgp(at)phlo(dot)org> writes:
> > On Jan11, 2011, at 18:09 , Garick Hamlin wrote:
> >> My gut was that direct io would likely work right on Linux
> >> and Solaris, at least.
>
> > Didn't we discover recently that O_DIRECT fails for ext4 on linux
> > if ordered=data, or something like that?
>
> Quite. Blithe assertions that something like this "should work" aren't
> worth the electrons they're written on.
Indeed. I wasn't making such a claim in case that wasn't clear. I believe,
in fact, there is no single way that will work everywhere. This isn't
needed for correctness of course, it is merely a tweak for performance as
long as the 'not working case' on platform + filesystem X case degrades to
something close to what would have happened if we didn't try. I expected
POSIX_FADV_NOREUSE not to work on Linux, but haven't looked at it recently
and not all systems are Linux so I mentioned it. This was why I thought
direct io might be more realistic.
I did not have a chance to test before I wrote this email so I attempted to
make my uncertainty clear. I _know_ it will not work in some environments,
but I thought it was worth looking at if it worked on more than one sane
common setup, but I can understand if you feel differently about that.
Garick
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2011-01-11 18:28:20 | Re: SSI and 2PC |
Previous Message | Heikki Linnakangas | 2011-01-11 18:17:20 | Allowing multiple concurrent base backups |