Re: problems with large objects dump

From: Sergio Gabriel Rodriguez <sgrodriguez(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: problems with large objects dump
Date: 2012-10-15 10:19:30
Message-ID: CAMHBdEp-gwK4_ti5t+thqK_gJTGGC33Xe1NB6=YA1sN-ga5etA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Oct 12, 2012 at 10:31 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message lst_hoe02 2012-10-15 11:30:09 Re: WebSphere Application Server support for postgres
Previous Message Dave Page 2012-10-15 08:28:13 Re: WebSphere Application Server support for postgres