Re: problem creating hash index - Mailing list pgsql-admin

HENAFF Mari-mai FTRD/DMI/LAN wrote:
>
> 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.

what's the difference between b-tree and hashed indexes ?

--
Mathieu Arnold