Re: PostgreSQL 8.4 performance tuning questions - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: PostgreSQL 8.4 performance tuning questions
Date
Msg-id 20090804153025.GH6494@alvh.no-ip.org
Whole thread Raw
In response to Re: PostgreSQL 8.4 performance tuning questions  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: PostgreSQL 8.4 performance tuning questions
List pgsql-performance
Merlin Moncure escribió:
> On Mon, Aug 3, 2009 at 5:30 PM, PFC<lists@peufeu.com> wrote:
> >
> >> lzo is much, much, (much) faster than zlib.  Note, I've tried several
> >
> > decompression speed is even more awesome...
> >
> >> times to contact the author to get clarification on licensing terms
> >> and have been unable to get a response.
> >
> > lzop and the LZO library are distributed under the terms of the GNU General
> > Public License (GPL).
> > source : http://www.lzop.org/lzop_man.php
>
> yeah...I have another project I'm working on that is closed source,
> plus I was curious if something could be worked out for pg...lzo seems
> ideal for database usage.

I think this was already discussed here.  It turns out that a specific
exception for PG wouldn't be acceptable because of the multiple
commercial derivates.  LZO would have to become BSD, which presumably
the author just doesn't want to do.

Maybe we could have a --enable-lzo switch similar to what we do with
readline.  Of course, a non-LZO-enabled build would not be able to read
a dump from such a build.  (We could also consider LZO for TOAST
compression).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Query help