Postgres Pro
Downloads
Home   >   mailing lists

Re: cannot get CREATE TABLE AS to work - Mailing list pgsql-sql

From Tom Lane
Subject Re: cannot get CREATE TABLE AS to work
Date
Msg-id 7158.984157978@sss.pgh.pa.us
Whole thread Raw
In response to cannot get CREATE TABLE AS to work  ("Creager, Robert S" <CreagRS@LOUISVILLE.STORTEK.COM>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: cannot get CREATE TABLE AS to work
Next
From: Josh Berkus
Date:
Subject: Re: cannot get CREATE TABLE AS to work