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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
