Re: PostgreSQL 8.4 performance tuning questions

От: Alvaro Herrera
Тема: Re: PostgreSQL 8.4 performance tuning questions
Дата: ,
Msg-id: 20090804153025.GH6494@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: PostgreSQL 8.4 performance tuning questions  (Merlin Moncure)
Ответы: Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey)
Список: pgsql-performance

Скрыть дерево обсуждения

PostgreSQL 8.4 performance tuning questions  (Rauan Maemirov, )
 Re: PostgreSQL 8.4 performance tuning questions  (, )
  Re: PostgreSQL 8.4 performance tuning questions  (Rauan Maemirov, )
   Re: PostgreSQL 8.4 performance tuning questions  (Merlin Moncure, )
 Re: PostgreSQL 8.4 performance tuning questions  (, )
  Re: PostgreSQL 8.4 performance tuning questions  (Rauan Maemirov, )
  Re: PostgreSQL 8.4 performance tuning questions  (Steve Crawford, )
   Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
    Re: PostgreSQL 8.4 performance tuning questions  (Steve Crawford, )
    Re: PostgreSQL 8.4 performance tuning questions  (Matthew Wakeling, )
     Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
      Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane, )
       Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
       Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
        Re: PostgreSQL 8.4 performance tuning questions  (Stefan Kaltenbrunner, )
         Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
          Re: PostgreSQL 8.4 performance tuning questions  (Stefan Kaltenbrunner, )
        Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
         Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
          Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
           Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
            Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
             Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
             Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane, )
              Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
               Re: PostgreSQL 8.4 performance tuning questions  (Rauan Maemirov, )
              Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
               Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane, )
                Re: PostgreSQL 8.4 performance tuning questions  (Greg Stark, )
                 Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner", )
                 Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane, )
                  Re: PostgreSQL 8.4 performance tuning questions  (PFC, )
                   Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
                    Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane, )
                     Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
                     Re: PostgreSQL 8.4 performance tuning questions  (Merlin Moncure, )
                      Re: PostgreSQL 8.4 performance tuning questions  (PFC, )
                       Re: PostgreSQL 8.4 performance tuning questions  (Merlin Moncure, )
                        Re: PostgreSQL 8.4 performance tuning questions  (Alvaro Herrera, )
                         Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
                          Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane, )
                           Re: PostgreSQL 8.4 performance tuning questions  (Merlin Moncure, )
                            Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
                    Re: PostgreSQL 8.4 performance tuning questions  (PFC, )
            Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane, )
         Re: PostgreSQL 8.4 performance tuning questions  (Arjen van der Meijden, )
       Re: PostgreSQL 8.4 performance tuning questions  (Stefan Kaltenbrunner, )
        Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
         Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane, )
          Re: PostgreSQL 8.4 performance tuning questions  (Scott Carey, )
 Re: PostgreSQL 8.4 performance tuning questions  (Greg Smith, )
  Re: PostgreSQL 8.4 performance tuning questions  (Scott Marlowe, )
   Re: PostgreSQL 8.4 performance tuning questions  (Rauan Maemirov, )

Merlin Moncure escribió:
> On Mon, Aug 3, 2009 at 5:30 PM, PFC<> 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 по дате сообщения:

От: Ibrahim Harrani
Дата:
Сообщение: postgresql and syslog
От: Robert Haas
Дата:
Сообщение: Re: GiST, caching, and consistency