Re: Compression of full-page-writes

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Compression of full-page-writes
Date: 2013-08-30 03:43:33
Message-ID: CAM3SWZQGGgKUKt_P+m3jpce7um=MbPKHwOrhez_O_8ncgG8NFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Aug 29, 2013 at 7:55 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> [the amount of WAL generated during running pgbench]
> 4302 MB (compress_backup_block = off)
> 1521 MB (compress_backup_block = on)

Interesting.

I wonder, what is the impact on recovery time under the same
conditions? I suppose that the cost of the random I/O involved would
probably dominate just as with compress_backup_block = off. That said,
you've used an SSD here, so perhaps not.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2013-08-30 04:43:53 Re: Compression of full-page-writes
Previous Message Satoshi Nagayasu 2013-08-30 03:20:59 Re: Compression of full-page-writes