Re: PostgreSQL 8.4 performance tuning questions

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: PostgreSQL 8.4 performance tuning questions
Дата
Msg-id 4A71D1900200002500029175@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PostgreSQL 8.4 performance tuning questions  (Rauan Maemirov <rauan@maemirov.com>)
Список pgsql-performance
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Scott Carey <scott@richrelevance.com> writes:
>> Gzip does have some quirky performance behavior depending on the
>> chunk size of data you stream into it.
>
> Can you enlarge on that comment?  I'm not sure that pg_dump is aware
> that there's anything to worry about there.

If the library used here is anything like the native library used by
Java, it'd be worth putting a buffer layer ahead of the calls to gzip,
so it isn't dealing with each individual value as a separate call.  I
seem to remember running into that issue in Java, where throwing a
BufferedOutputStream in there fixed the performance issue.

-Kevin

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 8.4 performance tuning questions
Следующее
От: Rauan Maemirov
Дата:
Сообщение: Re: PostgreSQL 8.4 performance tuning questions