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 по дате отправления:

Предыдущее
От: Alvar Freude
Дата:
Сообщение: Indexes not used in 7.1RC4: Bug?
Следующее
От: newsreader@mediaone.net
Дата:
Сообщение: Re: perl dbi:pg