Re: TOAST compression

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: TOAST compression
Дата
Msg-id 20060226160046.GX82012@pervasive.com
обсуждение исходный текст
Ответ на TOAST compression  (Neil Conway <neilc@samurai.com>)
Ответы Re: TOAST compression  ("Luke Lonergan" <llonergan@greenplum.com>)
Список pgsql-hackers
On Sat, Feb 25, 2006 at 09:39:34PM -0500, Neil Conway wrote:
> It's true that LZ decompression is fast, so we should probably use the
> compressed version of the datum unless the reduction in size is very
> small. I'm not sure precisely what that threshold should be, however.

Any idea on how decompression time compares to IO bandwidth? In other
words, how long does it take to decompress 1MB vs read that 1MB vs read
whatever the uncompressed size is?
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: possible design bug with PQescapeString()
Следующее
От: Tom Lane
Дата:
Сообщение: Re: TOAST compression