From: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Berkus <josh@agliodbs.com>
Cc: Zeugswetter Andreas ADI SD <ZeugswetterA@spardat.at>
Cc: pgsql-hackers@postgresql.org, "Koichi Suzuki" <suzuki.koichi@oss.ntt.co.jp>
Cc: pgsql-patches@postgresql.org
Subject: Re: [HACKERS] Full page writes improvement, code update
Date: Wed, 25 Apr 2007 17:55:04 -0400
Message-ID: <6292.1177538104@sss.pgh.pa.us> (raw)
In-Reply-To: <200704251127.13624.josh@agliodbs.com>
References: <460886E8.6040907@oss.ntt.co.jp>
<200704240831.42873.josh@agliodbs.com>
<E1539E0ED7043848906A8FF995BDA57901F40143@m0143.s-mxs.net>
<200704251127.13624.josh@agliodbs.com>
Josh Berkus <josh@agliodbs.com> writes:
> Andreas,
>> So imho pg_compresslog is the correct path forward. The current
>> discussion is only about whether we want a more complex pg_compresslog
>> and no change to current WAL, or an increased WAL size for a less
>> complex implementation.
>> Both would be able to compress the WAL to the same "archive log" size.
> Huh? As conceived, pg_compresslog does nothing to lower log volume for
> general purposes, just on-disk storage size for archiving. It doesn't help
> us at all with the tremendous amount of log we put out for an OLTP server,
> for example.
I don't see how what you said refutes what he said. The sticking point
here is that the patch as-proposed *increases* the log volume before
compression.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, josh@agliodbs.com, ZeugswetterA@spardat.at, suzuki.koichi@oss.ntt.co.jp, pgsql-patches@postgresql.org
Subject: Re: [HACKERS] Full page writes improvement, code update
In-Reply-To: <6292.1177538104@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox