Re: Bgwriter strategies

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bgwriter strategies
Дата
Msg-id 25511.1184166992@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bgwriter strategies  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Список pgsql-hackers
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> I think you are assuming that the next write of the same block won't
> use another OS cache block. I doubt if thats the way writes are handled
> by the kernel. Each write would typically end up being queued up in the
> kernel
> where each write will have its own copy of the block to the written. Isn't
> it ?

A kernel that worked like that would have a problem doing read(), ie,
it'd have to search to find the latest version of the block.  So I'd
expect that most systems would prefer to keep only one in-memory copy
of any given block and overwrite it at write() time.  No sane kernel
designer will optimize write() at the expense of read() performance,
especially when you consider that a design as above really pessimizes
write() too --- it does more I/O than is necessary when the same block
is modified repeatedly in a short time.
        regards, tom lane


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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: 2PC-induced lockup
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: 2PC-induced lockup