Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES
Date
Msg-id 919.1001517300@sss.pgh.pa.us
Whole thread Raw
In response to PERFORMANCE IMPROVEMENT by mapping WAL FILES  (Janardhana Reddy <jana-reddy@mediaring.com.sg>)
List pgsql-hackers
Janardhana Reddy <jana-reddy@mediaring.com.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: iscacheable for date/time?
Next
From: Tom Lane
Date:
Subject: Re: optimizer question