mlw wrote: > I have the USA tiger census data in a database, it is over 60G with > indexes, 30G+ of just data. Do you know how long that will take to dump > and restore? Making one index on some of the tables takes 20 minutes.
Oh, come on. How many tigers are their in the USA? Certainly not 30G+ worth. ;-) -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org