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

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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: Christophe <xof(at)thebuild(dot)com>, pgsql List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Are there plans to add data compression feature to postgresql?
Date: 2008-10-30 15:54:23
Message-ID: 4909D8AF.7020401@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-general
Grzegorz Jaśkiewicz wrote:
> 
> 
> On Thu, Oct 30, 2008 at 3:27 PM, Christophe <xof(at)thebuild(dot)com 
> <mailto:xof(at)thebuild(dot)com>> wrote:
> 
>     I'm a bit surprised to hear that; what would pg be doing, unique to
>     it, that would cause it to be slower on a RAID-1 cluster than on a
>     plain drive?
> 
> yes, it is slower on mirror-raid from single drive.
> I can give you all the /proc/* dumps if you want, as far as computer 
> goes, it isn't anything fancy. dual way p4, and sata drives of some sort.

O.k. that doesn't actually surprise me all that much. Software RAID 1 on 
SATA Drives for specific workloads would be slower than a single drive. 
It should still be faster for reads assuming some level of concurrency 
but not likely faster for a single thread. Writes would be expected to 
be slower because you are managing across two spindles, identical writes 
and SATA is slow for that type of thing.

Joshua D. Drake

>  
> 
>      
> 
> 
> 
> 
> -- 
> GJ


In response to

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2008-10-30 17:13:16
Subject: Re: Decreasing WAL size effects
Previous:From: Grzegorz JaśkiewiczDate: 2008-10-30 15:42:33
Subject: Re: Are there plans to add data compression feature to postgresql?

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