problem creating hash index

From: HENAFF Mari-mai FTRD/DMI/LAN <marimai(dot)henaff(at)rd(dot)francetelecom(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: problem creating hash index
Date: 2000-09-05 14:39:13
Message-ID: 7D59335FDAE0D011A3350060974B1C720318EBD1@l-mhs3.lannion.cnet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have a problem creating a hash index : it's too slow (it takes several
days, i stopped it before the end).
When i create a b-tree index on the same field, it takes approximately
twenty minutes.
The type of the field indexed is Varchar(16). The table indexed contains 20
MO of rows.

Thanks for your help,
M. Henaff

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mathieu Arnold 2000-09-05 14:52:11 Re: problem creating hash index
Previous Message Rafa Couto 2000-09-04 16:33:46 RE: disable auto-commit