Re: Compressing WAL - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Compressing WAL
Date
Msg-id 20050413222720.GE58835@decibel.org
Whole thread Raw
In response to Re: Compressing WAL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Mischa Sandberg
Date:
Subject: Strange serialization problem
Next
From: Simon Riggs
Date:
Subject: Re: Compressing WAL