Skip site navigation (1) Skip section navigation (2)

Re: pg_restore quick question

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore quick question
Date: 2004-05-27 22:13:43
Message-ID: 601xl5bjs8.fsf@dev6.int.libertyrms.info (view raw or flat)
Thread:
Lists: pgsql-general
dedeb17(at)hotmail(dot)com ("Sally Sally") writes:
> I want to dump a database containing about five tables, each
> containing about 25 million records. I wanted to run pg_restore per
> table all at the same time. Would this have any undesirable
> consequences. I tried it on a smaller database and it seems to work
> fine.
> Let me know your thoughts ASAP

Performance may be questionable, and if they touch the same table,
it's possible for there to be deadlocks, but aside from that, it
should generally _work_.
-- 
"cbbrowne","@","ntlug.org"
http://www3.sympatico.ca/cbbrowne/linuxxian.html
DO IT -- it's easier to get forgiveness than permission.

In response to

pgsql-general by date

Next:From: Jan WieckDate: 2004-05-27 22:32:09
Subject: Re: Naive schema questions
Previous:From: Rory Campbell-LangeDate: 2004-05-27 22:03:08
Subject: Re: Naive schema questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group