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