Parallel pg_dump/restore and LOs

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Parallel pg_dump/restore and LOs
Date: 2016-11-06 11:34:10
Message-ID: VisenaEmail.4.a42ac27798261a5a.1583967c7c8@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.
 
When dumping large-objects it doesn't appear that it's done in parallel,
meaning only one thread for dumping all LOs. Is this the case?
When pg_dump comes to dumping large-objects it outputs (when -v is specified):
pg_dump: saving large objects
Then it seems only 1 CPU is working.
 
Are there some plans to make dumping large tables (typically LOs) benefit from
parallelism?
 
Thanks.
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Adams 2016-11-06 14:11:57 timestamp without timezone to have timezone
Previous Message Adrian Klaver 2016-11-05 19:43:12 Re: RES: Trouble with regexp_matches