Re: [SQL] cannot get CREATE TABLE AS to work

[Tom Lane]

"Creager, Robert S" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl