On Thu, Jul 30, 2009 at 11:30 PM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)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?
In response to
pgsql-performance by date
|Next:||From: Kevin Grittner||Date: 2009-07-30 22:49:14|
|Subject: Re: PostgreSQL 8.4 performance tuning questions|
|Previous:||From: Tom Lane||Date: 2009-07-30 22:30:20|
|Subject: Re: PostgreSQL 8.4 performance tuning questions |