Re: Block-level CRC checks

Поиск
Список
Период
Сортировка
От Aidan Van Dyk
Тема Re: Block-level CRC checks
Дата
Msg-id 20081002001740.GJ16893@yugib.highrise.ca
обсуждение исходный текст
Ответ на Re: Block-level CRC checks  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Block-level CRC checks  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-hackers
* Tom Lane <tgl@sss.pgh.pa.us> [081001 19:42]:
> Gregory Stark <stark@enterprisedb.com> writes:
> > a) You wouldn't have to keep the lock while doing the I/O.
> 
> Hoo, yeah, so the period of holding the share-lock could well be
> *shorter* than it is now.  Most especially so if the write() blocks
> instead of just transferring the data to kernel space and returning.
> 
> I wonder whether that could mean that it's a win to double-buffer
> even if we aren't computing a checksum?  Nah, probably not.

That all depends on what you think is longer: copy 8K & release, or
syscall(which obviously does a copy)+return & release... And whether you
want to shorten the lock hold time (but it's only shared), or the time
until write is done (isn't the goal to have writes being done in the
background during checkpoint so write latency isn't a problem)...  This
might be an interesting experiment for someone to do with a very high
concurrency, high-write load...

a.


-- 
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

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

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: September CommitFest Closed
Следующее
От: "Hitoshi Harada"
Дата:
Сообщение: Re: Common Table Expressions (WITH RECURSIVE) patch