Horton

Re: [HACKERS] now 6.4

Marc G. Fournier <scrappy@hub.org>

View thread View on postgr.es
From: The Hermit Hacker <scrappy@hub.org>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: vadim@krs.ru, dg@illustra.com, miker@hub.org, hackers@postgreSQL.org
Date: 1998-06-30T02:01:20Z
Lists: pgsql-hackers 
On Mon, 29 Jun 1998, Bruce Momjian wrote:

> > 	As for dropping/recreating all indices...that isn't really so bad,
> > anyway...once all the data is there, th edatabase can go live...albeit
> > *very* slow, in some cases, if I have 4 indices on a table, each one built
> > should improve the speed of queries, but each build shouldn't limit the
> > ability for the database to be up...
> 
> Doesn't index creation lock the table?

	I'm not sure why it would...creation of indices doesn't write
nything to the table itself, just reads...no?


Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org