Re: Page-at-a-time Locking Considerations

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема Re: Page-at-a-time Locking Considerations
Дата
Msg-id 47AA0C32.1030807@sun.com
обсуждение исходный текст
Ответ на Re: Page-at-a-time Locking Considerations  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Page-at-a-time Locking Considerations  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
>> I tried to use memory mapped files (mmap) for clog and I think it should be also 
>> possible way. I got about 2% better performance, but it needs more testing.
> 
> If you only got 2% out of it, it's not even worth thinking about how to
> fix the serious bugs that approach would create (primarily, lack of
> control over when pages can get flushed to disk).

You can flush a pages by msync() function which writes dirty pages on 
disk. I don't see any other problem. Originally I tried to fix problem 
with a lot of parallel issues reported by Jignesh. However, it needs 
more testing if it really helps.
    Zdenek



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: crash / data recovery issues
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why are we waiting?