Re: Compressing WAL

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Compressing WAL
Дата
Msg-id 20050413222720.GE58835@decibel.org
обсуждение исходный текст
Ответ на Re: Compressing WAL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-performance
On Sun, Apr 10, 2005 at 09:12:41PM -0400, Bruce Momjian wrote:
> I have never heard anyone talk about it, but it seems useful.  I think
> compressing the page images written on first page modification since
> checkpoint would be a big win.

Could you clarify that? Maybe I'm being naive, but it seems like you
could just put a compression routine between the log writer and the
filesystem.

> Is this a TODO?

ISTM it's at least worth hacking something together and doing some
performance testing...
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

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

Предыдущее
От: Mischa Sandberg
Дата:
Сообщение: Strange serialization problem
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Compressing WAL