hash indexing taking a lot of time.

Поиск
Список
Период
Сортировка
От Anand Raman
Тема hash indexing taking a lot of time.
Дата
Msg-id 20010410172314.A28316@india-today.com
обсуждение исходный текст
Список 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 по дате отправления: