Re: Archive log compression keeping physical log available in the crash recovery

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Archive log compression keeping physical log available in the crash recovery
Дата
Msg-id 20070209141105.GA20293@svana.org
обсуждение исходный текст
Ответ на Re: Archive log compression keeping physical log available in the crash recovery  (Koichi Suzuki <suzuki.koichi@oss.ntt.co.jp>)
Ответы Re: Archive log compression keeping physical log available in the crash recovery  (Koichi Suzuki <suzuki.koichi@oss.ntt.co.jp>)
Список pgsql-hackers
On Fri, Feb 09, 2007 at 01:00:10PM +0900, Koichi Suzuki wrote:
> Further, we can apply gzip to this archive (2.36GB).   Final size is
> 0.75GB, less than one sixtieth of the original WAL.

Note that if you were compressing on the fly, you'll have to tell gzip
to regularly flush its buffers to make sure all the data actually hits
disk. That cuts into your compression ratio...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: HOT for PostgreSQL 8.3
Следующее
От: Mark Cave-Ayland
Дата:
Сообщение: Re: Hierarchical Queries--Status