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

From Rauan Maemirov
Subject Re: PostgreSQL 8.4 performance tuning questions
Date
Msg-id c78bcec0907301502t3aec056cj9abd4894a711f78@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Hey guyz, thanks for help. I solved the problems. The reason was in
bad query, that i've accidentally committed right after upgrading.
PostgreSQL 8.4 is perfect! Analyze works like a charm, and MUCH better
than in 8.3.

2009/7/31 Kevin Grittner <Kevin.Grittner@wicourts.gov>:
> 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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: PostgreSQL 8.4 performance tuning questions
Next
From: Scott Carey
Date:
Subject: Re: PostgreSQL 8.4 performance tuning questions