Обсуждение: hash indexing taking a lot of time.

Поиск
Список
Период
Сортировка

hash indexing taking a lot of time.

От
Anand Raman
Дата:
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