Re: BUG #6528: pglesslog still referenced in docs, but no 9.1 support

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, "stuart(dot)bishop" <stuart(dot)bishop(at)canonical(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>, koichi(dot)szk(at)gmail(dot)com
Subject: Re: BUG #6528: pglesslog still referenced in docs, but no 9.1 support
Date: 2013-01-25 00:01:05
Message-ID: 20130125000105.GF8539@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2012-04-09 15:37:09 -0300, Alvaro Herrera wrote:
>
> Excerpts from Bruce Momjian's message of lun abr 09 15:13:10 -0300 2012:
> > On Mon, Apr 09, 2012 at 10:10:34AM -0400, Robert Haas wrote:
>
> > > This complaint appears to be accurate. I think we should go ahead and
> > > remove that mention.
> >
> > Agreed; removed with the attached patch. I didn't bother keeping the
> > gzip mention because I assume there is little value to using without
> > pglesslog.
>
> I'm not sure that assumption holds. I think you're thinking of the hack
> that zeroes out the "empty" holes in the middle of data pages; those
> didn't compress well unless zeroed out before compression. This tool is
> not about that, but rather about removing redundant info from WAL files.
> It seems to me that WAL files would be as gzip-compressible regardless
> of pglesslog being applied. (Another related tool is clearxlogtail
> which zeroes areas from WAL files when they are empty because of an
> early switch due to archive timeout).
>
> The funny thing is, apparently pg_lesslog was intentionally broken by
> changing XLR_BKP_REMOVABLE to XLP_BKP_REMOVABLE (different semantics?)
> and the fixes to make it compile again look simple. It's a bit strange
> that NTT stopped maintaining the tool .. Maybe it wasn't useful anymore?

One problem is that it was hard to trust the tool, it had relatively bad
bugs several times and it wasn't maintained by pgdg...

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-01-25 00:06:21 Re: PL/R Median Busts Commit (Postgres 9.1.6 + plr 8.3.0.13 on Ubuntu 12.10 64 bit)
Previous Message Bruce Momjian 2013-01-24 23:45:02 Re: BUG #6528: pglesslog still referenced in docs, but no 9.1 support