> 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
You still haven't answered the question - why are you doing separate
schema and data dumps then loading them. That will always be very,
very, very, very slow.
Just do a normal data+schema dump and it will restore quickly.
Chris