hash indexing taking a lot of time. - Mailing list pgsql-general

From Anand Raman
Subject hash indexing taking a lot of time.
Date
Msg-id 20010410172314.A28316@india-today.com
Whole thread Raw
List pgsql-general
hi guys

I am trying to hash index a 3 column table containing around 5,42,168 rows..

create index ind_url_status on urls using hash (status);

postmaster has been struglling for well over 30 mins as of now.. Does hash
indexing generally takes a lot of time..

The postmaster process has been started with sufficient number of shared
memory segment (-S 4096)

Can any one give some directions

version 7.0.3

Thanks
Anand

pgsql-general by date:

Previous
From: Alvar Freude
Date:
Subject: Indexes not used in 7.1RC4: Bug?
Next
From: newsreader@mediaone.net
Date:
Subject: Re: perl dbi:pg