>
> I think the right question to ask here is "why are you so intent on
> using separate schema/data restores?" That's not the recommended way
> to go about things, and it never will be.
>
> regards, tom lane
>
Simply because it took me more or less 24 hours to restore the dump when the
index is already defined. And it would only take less than an hour to
restore the
data without the index then create the index that would only take less than
10 minutes.
BTW I am using postgresql 8.1.3