Re: problems with large objects dump

Поиск
Список
Период
Сортировка
От Sergio Gabriel Rodriguez
Тема Re: problems with large objects dump
Дата
Msg-id CAMHBdEp-gwK4_ti5t+thqK_gJTGGC33Xe1NB6=YA1sN-ga5etA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: problems with large objects dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance


On Fri, Oct 12, 2012 at 10:31 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
So I think the original assumption that we didn't need to optimize
pg_dump's object management infrastructure for blobs still holds good.
If there's anything that is worth fixing here, it's the number of server
roundtrips being used ...


I found something similar

 samples|      %|
------------------
233391664 60.5655 no-vmlinux
 78789949 20.4461 libz.so.1.2.3
 31984753  8.3001 postgres
 21564413  5.5960 libc-2.4.so
  4086941  1.0606 ld-2.4.so
  2427151  0.6298 bash
  2355895  0.6114 libc-2.4.so
  2173558  0.5640 pg_dump
  1771931  0.4598 oprofiled

there are anything I can do to improve this? 

Thanks

Sergio

В списке pgsql-performance по дате отправления:

Предыдущее
От: Andrea Suisani
Дата:
Сообщение: Re: Two identical systems, radically different performance
Следующее
От: Robert Klemme
Дата:
Сообщение: Re: Query with limit goes from few ms to hours