Postgres Pro
Downloads
Home   >   mailing lists

Re: [REVIEW] Re: Compression of full-page-writes - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [REVIEW] Re: Compression of full-page-writes
Date
Msg-id 20140902133935.GA5805@awork2.anarazel.de
Whole thread Raw
In response to Re: [REVIEW] Re: Compression of full-page-writes  ("ktm@rice.edu" <ktm@rice.edu>)
List pgsql-hackers
Tree view 
On 2014-09-02 08:37:42 -0500, ktm@rice.edu wrote:
> I agree completely. For day-to-day use we should use LZ4-default. For read-only
> tables, it might be nice to "archive" them with LZ4-HC for the higher compression
> would increase read speed and reduce storage space needs. I believe that LZ4-HC
> is only slower to compress and the decompression is unaffected.

This is about the write ahead log, not relations

Greetings,

Andres Freund

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

pgsql-hackers by date:

Previous
From: "ktm@rice.edu"
Date:
Subject: Re: [REVIEW] Re: Compression of full-page-writes
Next
From: Albe Laurenz
Date:
Subject: Re: Optimization for updating foreign tables in Postgres FDW