Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES
Дата
Msg-id 919.1001517300@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PERFORMANCE IMPROVEMENT by mapping WAL FILES  (Janardhana Reddy <jana-reddy@mediaring.com.sg>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: iscacheable for date/time?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: optimizer question