On 2/20/19 6:16 PM, Adrian Klaver wrote:
On 2/20/19 2:22 PM, Tiffany Thang wrote:
Hi Adrian,
I managed to backup my table in parallel using -Fd but I'm back to my
original issue where I could not restore the table to a different schema.
For example,
I would like to backup testuser1.mytable and restore it to
testuser2.mytable.
pg_dump -U testuser1 -Fd -f c:\temp\testuser1 -j 8 -t mytable -h myserver
testdb
Is table mytable big enough to actually need 8 parallel jobs?
A single table will only use a single thread, no matter how big it is, no?
(That is my experience with v9.6, at least.)
--
Angular momentum makes the world go 'round.
