problem creating hash index - Mailing list pgsql-admin

From HENAFF Mari-mai FTRD/DMI/LAN
Subject problem creating hash index
Date
Msg-id 7D59335FDAE0D011A3350060974B1C720318EBD1@l-mhs3.lannion.cnet.fr
Whole thread Raw
List 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




pgsql-admin by date:

Previous
From: "Rafa Couto"
Date:
Subject: RE: disable auto-commit
Next
From: Mathieu Arnold
Date:
Subject: Re: problem creating hash index