Re: Compressing WAL

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Compressing WAL
Date: 2005-04-13 22:27:20
Message-ID: 20050413222720.GE58835@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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(at)decibel(dot)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?"

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-04-13 23:33:42 Re: Compressing WAL
Previous Message Mark Wong 2005-04-13 20:41:48 Re: PLM pulling from CVS nightly for testing in STP

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2005-04-13 23:33:42 Re: Compressing WAL
Previous Message Mischa Sandberg 2005-04-13 22:16:54 Strange serialization problem