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

Re: Are there plans to add data compression feature to postgresql?

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Are there plans to add data compression feature to postgresql?
Date: 2008-10-30 05:26:26
Message-ID: 78CCABE6-4914-47C7-8972-80ACD4CEF62B@blighty.com (view raw or flat)
Thread:
Lists: pgsql-general
On Oct 29, 2008, at 9:50 PM, Grant Allen wrote:
>
>
> One other thing I forgot to mention:  Compression by the DB trumps  
> filesystem compression in one very important area - shared_buffers!  
> (or buffer_cache, bufferpool or whatever your favourite DB calls its  
> working memory for caching data).  Because the data stays compressed  
> in the block/page when cached by the database in one of its buffers,  
> you get more bang for you memory buck in many circumstances!  Just  
> another angle to contemplate :-)

The additional latency added by decompression is reasonably small  
compared with traditional disk access time. It's rather large compared  
to memory access time.

Cheers,
   Steve


In response to

Responses

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2008-10-30 05:43:29
Subject: Re: Are there plans to add data compression feature to postgresql?
Previous:From: noviceDate: 2008-10-30 04:55:31
Subject: phone database schema

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