Re: cannot get CREATE TABLE AS to work

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Creager, Robert S" <CreagRS(at)LOUISVILLE(dot)STORTEK(dot)COM>
Cc: "'SQL - PGSQL'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: cannot get CREATE TABLE AS to work
Date: 2001-03-09 17:12:58
Message-ID: 7158.984157978@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Creager, Robert S" <CreagRS(at)LOUISVILLE(dot)STORTEK(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-03-09 18:36:55 Re: cannot get CREATE TABLE AS to work
Previous Message Josh Berkus 2001-03-09 17:09:57 Re: cannot get CREATE TABLE AS to work