Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES

Janardhana Reddy <jana-reddy(at)mediaring(dot)com(dot)sg> writes:
> By mapping the WAL files by each backend in to its address
> space using "mmap" system call ,

There are a lot of problems with trying to use mmap for Postgres. One
is portability: not all platforms have mmap, so we'd still have to
support the non-mmap case; and it's not at all clear that fsync/msync
semantics are consistent across platforms, either. A bigger objection
is that mmap'ing a file in one backend does not cause it to become
available to other backends, thus the entire concept of shared buffers
breaks down.

If you think you can make it work, feel free to try it ...

regards, tom lane