Postgres Pro
Downloads
Home   >   mailing lists

Re: problems with large objects dump - Mailing list pgsql-performance

From Sergio Gabriel Rodriguez
Subject Re: problems with large objects dump
Date
Msg-id CAMHBdEp-gwK4_ti5t+thqK_gJTGGC33Xe1NB6=YA1sN-ga5etA@mail.gmail.com
Whole thread Raw
In response to Re: problems with large objects dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view


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 by date:

Previous
From: Andrea Suisani
Date:
Subject: Re: Two identical systems, radically different performance
Next
From: Robert Klemme
Date:
Subject: Re: Query with limit goes from few ms to hours