>>>>> "JS" == Joseph Shraibman <jks@selectacast.net> writes:
JS> Indexes aren't as big a deal. Reindexing is less painful than
JS> dump/restore. It could still lead to significant downtime for very
JS> large databases (at least the for the tables that are being
JS> reindexed), but not nearly as much.
Well, for me the create index part of the restore is what takes about
3x the time for the data load. Total about 4 hours. The dump takes 1
hour.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/