Re: suggestion

> 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