On 7/30/09 1:15 PM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > Scott Carey <scott@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
