pg_restore quick question

[Sally Sally]

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
Thanks
Sally

__________________________________________________ _______________
Is your PC infected? Get a FREE online computer virus scan from McAfee®
Security. http://clinic.mcafee.com/clinic/ibuy...n.asp?cid=3963
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Chris Browne]

de*****@hotmail.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.