Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f29HE0x88806 for ; Fri, 9 Mar 2001 12:14:00 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f29HCx907161; Fri, 9 Mar 2001 12:12:59 -0500 (EST) To: "Creager, Robert S" cc: "'SQL - PGSQL'" Subject: Re: cannot get CREATE TABLE AS to work In-reply-to: <10FE17AD5F7ED31188CE002048406DE8514CDD@lsv-msg06.stortek.com> References: <10FE17AD5F7ED31188CE002048406DE8514CDD@lsv-msg06.stortek.com> Comments: In-reply-to "Creager, Robert S" message dated "Fri, 09 Mar 2001 09:21:32 -0700" Date: Fri, 09 Mar 2001 12:12:58 -0500 Message-ID: <7158.984157978@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/199 X-Sequence-Number: 1853 "Creager, Robert S" 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