On 1/12/07, Martijn van Oosterhout <firstname.lastname@example.org> wrote:
On Thu, Jan 11, 2007 at 02:35:13PM -0800, [EMAIL PROTECTED] wrote:
> I caught this thread about O_DIRECT on kerneltrap.org:
> It sounds like there is much to be gained here in terms of reducing
> the number of user/kernel space copies in the operating system. I got
> the impression that posix_fadvise in the Linux kernel isn't as good as
> it could be. I noticed in xlog.c that the use of posix_fadvise is
> disabled. Maybe it's time to do some more experimenting and working
> with the Linux kernel developers. Or perhaps there is another OS that
> would be better to experiment with?
Postgres doesn't use O_DIRECT and probably never will. The system is
esigned to use the system cache, not bypass it.
What recent discussions have highlighted is the need to more accurately
control the flow of data to disk. Apparently currently kernel try to
hold data back much longer than is useful.
Right, so my understanding is that.PostgreSQL needs to provide the OS
with information with how it wants it to control the flow with
posix_fadvise, and it sounds like the Linux folks believe their
implementation of posix_fadvise needs some work.
Not that I'm volunterring to deal with this.
Have a nice day,
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings