Re: pg_dump additional options for performance - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump additional options for performance
Date
Msg-id 6124.1204052305@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump additional options for performance  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: pg_dump additional options for performance
Re: pg_dump additional options for performance
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> IMO the place to start is COPY which is per my tests, slow. Multi
> worker connection restore is great and I have proven that with some
> work it can provide o.k. results but it is certainly not acceptable.

It was already pointed out to you that we can hope for only incremental
speedups in COPY per se.  Don't be too quick to dismiss the discussion
of large-grain parallelism, because I don't see anything else within
reach that might give integer multiples rather than percentage points.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposed changes to DTrace probe implementation
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_dump additional options for performance