Re: [GENERAL] medical image on postgreSQL?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: [GENERAL] medical image on postgreSQL?
Дата
Msg-id 87wui0prc4.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: [GENERAL] medical image on postgreSQL?  (Sean Chittenden <sean@chittenden.org>)
Ответы Re: [GENERAL] medical image on postgreSQL?
Список pgsql-hackers
Sean Chittenden <sean@chittenden.org> writes:

> Other zero copy socket operations are mmap() + write(), but last I heard,
> that was a FreeBSD only thing... for now. man 2 sendfile

There's a lot of resistance to the optimizating mmap+write in the linux camp.
It isn't just a matter of time, the developers there actively think this is a
bad idea. In fact the code has been written several times and is never
accepted. They think developers should be encouraged to use sendfile and the
common code path for write shouldn't be wasting cycles checking for  special
cases in the page table.

Note that there are some protocol requirements for sendfile to be feasible.
There has to be zero alterations made to the data in flight. No escaping,
decompression, etc. And there has to be no cases when the program would want
to stop transmitting partway through. I think you can send a portion of a file
but you would have to know the size of the chunk up front and the best
performance would be if the chunk is very large.

--
greg



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

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: How do you execute a postgresql function from perl?
Следующее
От: David Blasby
Дата:
Сообщение: backend dies when C function calls C++ library that throws an exception