| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mike Roest <mike(dot)roest(at)replicon(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump incredibly slow dumping a single schema from a large db |
| Date: | 2012-03-30 17:49:24 |
| Message-ID: | 25164.1333129764@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Mike Roest <mike(dot)roest(at)replicon(dot)com> writes:
> That was on the CentOS 5.8 x64 machine. The one I'm trying it from now is
> Ubuntu 11.10 x64
Hm. On current Red-Hat-derived systems I'd recommend oprofile, although
you need root privileges to use that. Not real sure what is available
on Ubuntu, but our crib sheet for oprofile says it doesn't currently
work there:
http://wiki.postgresql.org/wiki/Profiling_with_OProfile
That could be out-of-date info though. Here's some info about
another possibility:
http://wiki.postgresql.org/wiki/Profiling_with_perf
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | clover white | 2012-03-30 17:52:37 | where to find initdb log file? |
| Previous Message | Alan Hodgson | 2012-03-30 17:44:25 | Re: ERROR: invalid byte sequence for encoding "UTF8": 0xc325 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-03-30 17:51:41 | Re: tracking context switches with perf record |
| Previous Message | Daniel Farina | 2012-03-30 17:44:20 | Re: HTTP Frontend? (and a brief thought on materialized views) |