Received: from mta2.snfc21.pbi.net (mta2.snfc21.pbi.net [206.13.28.123]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA16030 for ; Mon, 25 Oct 1999 12:47:15 -0400 (EDT) (envelope-from postgres@weblynk.com) Received: from pinto.usedcars.com ([206.170.239.155]) by mta2.snfc21.pbi.net (Sun Internet Mail Server sims.3.5.1999.09.16.21.57.p8) with SMTP id <0FK6006B03QD79@mta2.snfc21.pbi.net> for pgsql-sql@postgreSQL.org; Mon, 25 Oct 1999 09:42:13 -0700 (PDT) Date: Mon, 25 Oct 1999 09:39:54 -0700 From: Rich Ryan Subject: Create index pretty slow To: "pgsql-sql@postgresql.org" Message-id: <004e01bf1f07$9127ccc0$9befaace@usedcars.com> MIME-version: 1.0 X-Mailer: Microsoft Outlook Express 5.00.2314.1300 Content-type: text/plain; charset="iso-8859-1" Content-transfer-encoding: 7bit X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 References: <18149.940866911@sss.pgh.pa.us> X-Priority: 3 The following command takes about 30 min. to complete CREATE INDEX "cfsoid" on "cfs" using hash ( "ownerid" "float8_ops" ); The table cfs has about 30 columns and 200K rows at the time of creation. Does the time for this command sound right? I'm using the REL6_5 branch from CVS