Postgres Pro
Downloads
Home   >   mailing lists

Create index pretty slow - Mailing list pgsql-sql

From Rich Ryan
Subject Create index pretty slow
Date
Msg-id 004e01bf1f07$9127ccc0$9befaace@usedcars.com
Whole thread Raw
In response to Re: [SQL] Vacuum takes more than 1 hr  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Albert REINER"
Date:
Subject: Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] Week of year function?