"Creager, Robert S" <CreagRS@LOUISVILLE.STORTEK.COM> writes:
> And the next question, should this really be taking 3 hours to insert 315446
> records? I noticed the disk is basically idle during the few times when I
> watched. Would this be because of the index created on obs_id?
Not for a single index. I can believe that the referential integrity
checks you're requiring on file_id and star_id might take that much
time, however.
regards, tom lane