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

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

From: "Thomas Samson" <koollman(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 小波 顾 <guxiaobo1982(at)hotmail(dot)com>, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, chris(dot)ellis(at)shropshire(dot)gov(dot)uk, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Are there plans to add data compression feature to postgresql?
Date: 2008-10-31 14:39:04
Message-ID: 4e96c6600810310739r2345d3d2y84393773793abaff@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Oct 31, 2008 at 3:01 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com>wrote:

> Scott Marlowe escribió:
> > On Thu, Oct 30, 2008 at 7:37 PM, Alvaro Herrera
> > <alvherre(at)commandprompt(dot)com> wrote:
> > > Scott Marlowe escribió:
> > >
> > >> What is the torn page problem?  Note I'm no big fan of compressed file
> > >> systems, but I can't imagine them not working with databases, as I've
> > >> seen them work quite reliably under exhange server running a db
> > >> oriented storage subsystem.  And I can't imagine them not being
> > >> invisible to an application, otherwise you'd just be asking for
> > >> trouble.
> > >
> > > Exchange, isn't that the thing that's very prone to corrupted
> databases?
> > > I've heard lots of horror stories about that (and also about how you
> > > have to defragment the database once in a while, so what kind of
> > > database it really is?)
> >
> > Sure, bash Microsoft it's easy.   But it doesn't address the point, is
> > a database safe on top of a compressed file system and if not, why?
>
> I'm not bashing Microsoft.  I'm just saying that your example
> application already shows signs that could, perhaps, be explained by the
> hypothesis put forward by Greg -- that a compressed filesystem is more
> prone to corruption.
>

Each added layer could lead to corruption/instability.

Yet, some people might be willing to try out  some of these layers
to enhance functionnality.

Postgresql already uses an OS, and even an fs! Why would it decide to not
recode it's own raw device handler ... like some serious db ;)

-- 
Thomas SAMSON
Simplicity does not precede complexity, but follows it.

In response to

pgsql-general by date

Next:From: tomas.kejzlar@gmail.comDate: 2008-10-31 14:53:39
Subject: plruby on windows
Previous:From: AaronDate: 2008-10-31 14:31:30
Subject: Re: Storage location of temporary files

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