On 7/30/09 1:15 PM, "Tom Lane" <t...@sss.pgh.pa.us> wrote:
> Scott Carey <sc...@richrelevance.com> writes: >> Dump needs to be parallelized or at least pipelined to use more cores. COPY >> on one thread, compression on another? > > We already do that (since compression happens on the pg_dump side). > > regards, tom lane > Well, that isn't what I meant. pg_dump uses CPU outside of compression doing various things, If that Cpu is 10% as much as the compression, then splitting them up would yield ~10% gain when CPU bound. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance