insertion times ..

From: Anand Raman <araman(at)india-today(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: insertion times ..
Date: 2000-11-29 12:44:16
Message-ID: 20001129181416.M2601@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi guys

I am trying to create a search facility for our site using udm search..
While reading about udm search along with postgresql i cam across this
line in one of the mailing list archived mails.

****************************************
> I don't know what kind of queries are executed during the indexing, if
> the insertions don't need indexes you could try to drop the index and
> recreate them when the indexing is done.

THIS SHOULD SIGNIFICANTLY INCREASE INDEXING TIME.
****************************************

Is it true that creating indexes after the insertion has been done takes
more time..
If so why ..

Thanx
Anand

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hancock, David (DHANCOCK) 2000-11-29 12:51:11 Help with Database Recovery
Previous Message Francis Solomon 2000-11-29 12:32:09 RE: is it a bug?