Re: Improve compression speeds in pg_lzcompress.c

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Improve compression speeds in pg_lzcompress.c
Дата
Msg-id 11201.1357575367@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Improve compression speeds in pg_lzcompress.c  (Takeshi Yamamuro <yamamuro.takeshi@lab.ntt.co.jp>)
Ответы Re: Improve compression speeds in pg_lzcompress.c  (Merlin Moncure <mmoncure@gmail.com>)
Re: Improve compression speeds in pg_lzcompress.c  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Takeshi Yamamuro <yamamuro.takeshi@lab.ntt.co.jp> writes:
> The attached is a patch to improve compression speeds with loss of
> compression ratios in backend/utils/adt/pg_lzcompress.c.

Why would that be a good tradeoff to make?  Larger stored values require
more I/O, which is likely to swamp any CPU savings in the compression
step.  Not to mention that a value once written may be read many times,
so the extra I/O cost could be multiplied many times over later on.

Another thing to keep in mind is that the compression area in general
is a minefield of patents.  We're fairly confident that pg_lzcompress
as-is doesn't fall foul of any, but any significant change there would
probably require more research.
        regards, tom lane



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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: json api WIP patch
Следующее
От: Robert Haas
Дата:
Сообщение: Re: ALTER .. OWNER TO error mislabels schema as other object type