Re: Compression and on-disk sorting

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DCP SD
Тема Re: Compression and on-disk sorting
Дата
Msg-id E1539E0ED7043848906A8FF995BDA5790105430A@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Compression and on-disk sorting  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: Compression and on-disk sorting
Список pgsql-hackers
> > Given that any time that happens we end up caring much less about
CPU
> > usage and much more about disk IO, for any of these cases that use
> > non-random access, compressing the data before sending it to disk
would
> > potentially be a sizeable win.
>
> Note however that what the code thinks is a spill to disk and what
> actually involves disk I/O are two different things.  If you think
> of it as a spill to kernel disk cache then the attraction is a lot
> weaker...

Yes, that is very true. However it would also increase the probability
that spill to disk is not needed, since more data fits in RAM.

It would probably need some sort of plugin architecture, since the
fastest compression algorithms (LZO) that also reach good ratios are
gpl.
LZO is proven to increase physical IO write speed with low CPU overhead.

Andreas


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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: psql feature thought
Следующее
От: "Zeugswetter Andreas DCP SD"
Дата:
Сообщение: Re: Compression and on-disk sorting