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

From Greg Stark
Subject Re: PostgreSQL 8.4 performance tuning questions
Date
Msg-id 407d949e0907301540gacb642du661515764bd16afc@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: PostgreSQL 8.4 performance tuning questions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Thu, Jul 30, 2009 at 11:30 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> I did some tracing and verified that pg_dump passes data to deflate()
> one table row at a time.  I'm not sure about the performance
> implications of that, but it does seem like it might be something to
> look into.

I suspect if this was a problem the zlib people would have added
internal buffering ages ago. I find it hard to believe we're not the
first application to use it this way.

I suppose it wouldn't be the first time a problem like this went
unfixed though. Is the zlib software actively maintained or was your
earlier comment implying it's currently an orphaned codebase?


--
greg
http://mit.edu/~gsstark/resume.pdf

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.4 performance tuning questions
Next
From: "Kevin Grittner"
Date:
Subject: Re: PostgreSQL 8.4 performance tuning questions