Re: PostgreSQL 8.4 performance tuning questions

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: PostgreSQL 8.4 performance tuning questions
Дата
Msg-id
407d949e0907301540gacb642du661515764bd16afc@mail.gmail.com
Ответ на
Список
Дерево обсуждения
PostgreSQL 8.4 performance tuning questions Rauan Maemirov <rauan@maemirov.com>
Re: PostgreSQL 8.4 performance tuning questions tv@fuzzy.cz
Re: PostgreSQL 8.4 performance tuning questions Rauan Maemirov <rauan@maemirov.com>
Re: PostgreSQL 8.4 performance tuning questions tv@fuzzy.cz
Re: PostgreSQL 8.4 performance tuning questions Steve Crawford <scrawford@pinpointresearch.com>
Re: PostgreSQL 8.4 performance tuning questions "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: PostgreSQL 8.4 performance tuning questions Steve Crawford <scrawford@pinpointresearch.com>
Re: PostgreSQL 8.4 performance tuning questions Matthew Wakeling <matthew@flymine.org>
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>
Re: PostgreSQL 8.4 performance tuning questions "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: PostgreSQL 8.4 performance tuning questions "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: PostgreSQL 8.4 performance tuning questions Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
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>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL 8.4 performance tuning questions "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: PostgreSQL 8.4 performance tuning questions Rauan Maemirov <rauan@maemirov.com>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL 8.4 performance tuning questions Greg Stark <gsstark@mit.edu>
Re: PostgreSQL 8.4 performance tuning questions Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL 8.4 performance tuning questions PFC <lists@peufeu.com>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure <mmoncure@gmail.com>
Re: PostgreSQL 8.4 performance tuning questions PFC <lists@peufeu.com>
Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure <mmoncure@gmail.com>
Re: PostgreSQL 8.4 performance tuning questions Alvaro Herrera <alvherre@commandprompt.com>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure <mmoncure@gmail.com>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions PFC <lists@peufeu.com>
Re: PostgreSQL 8.4 performance tuning questions "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: PostgreSQL 8.4 performance tuning questions "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: PostgreSQL 8.4 performance tuning questions Arjen van der Meijden <acmmailing@tweakers.net>
Re: PostgreSQL 8.4 performance tuning questions Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL 8.4 performance tuning questions Scott Carey <scott@richrelevance.com>
Re: PostgreSQL 8.4 performance tuning questions Rauan Maemirov <rauan@maemirov.com>
Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure <mmoncure@gmail.com>
Re: PostgreSQL 8.4 performance tuning questions Greg Smith <gsmith@gregsmith.com>
Re: PostgreSQL 8.4 performance tuning questions Scott Marlowe <scott.marlowe@gmail.com>
Re: PostgreSQL 8.4 performance tuning questions Rauan Maemirov <rauan@maemirov.com>
On Thu, Jul 30, 2009 at 11:30 PM, Tom Lane 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 по дате отправления
От: Tom Lane
Дата:
От: Kevin Grittner
Дата:
FAQ