471,084 Members | 1,024 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

pg_restore quick question

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)

Nov 23 '05 #1
1 955
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.
Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sam | last post: by
reply views Thread by andy morrow | last post: by
reply views Thread by Joshua D. Drake | last post: by
14 posts views Thread by Ron Johnson | last post: by
6 posts views Thread by Mike Charnoky | last post: by
7 posts views Thread by Tim Penhey | last post: by
1 post views Thread by ruben | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.