Skip site navigation (1) Skip section navigation (2)

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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: 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: 2012-04-09 18:37:09
Message-ID: 1333996309-sup-1157@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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?

-- 
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2012-04-09 18:51:49
Subject: Re: BUG #6528: pglesslog still referenced in docs, but no 9.1 support
Previous:From: Kevin GrittnerDate: 2012-04-09 18:32:51
Subject: Re: BUG #6528: pglesslog still referenced in docs, but no 9.1 support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group