insertion times ..
Anand Raman <araman@india-today.com>
From: Anand Raman <araman@india-today.com>
To: pgsql-general@postgresql.org
Date: 2000-11-29T12:44:16Z
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