hash indexing taking a lot of time.

From: Anand Raman <araman(at)india-today(dot)com>
To: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: hash indexing taking a lot of time.
Date: 2001-04-10 11:53:14
Message-ID: 20010410172314.A28316@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message newsreader 2001-04-10 12:08:36 Re: perl dbi:pg
Previous Message Alvar Freude 2001-04-10 10:37:20 Indexes not used in 7.1RC4: Bug?