Create index pretty slow

From: Rich Ryan <postgres(at)weblynk(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Create index pretty slow
Date: 1999-10-25 16:39:54
Message-ID: 004e01bf1f07$9127ccc0$9befaace@usedcars.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1999-10-25 17:14:11 Re: [SQL] Week of year function?
Previous Message BOUARD, Fabrice 1999-10-25 16:21:00 unsubscribe