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 по дате отправления