Horton

Re: [HACKERS] now 6.4

Vadim Mikheev <vadim@krs.ru>

View thread View on postgr.es
From: Vadim Mikheev <vadim@krs.ru>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: The Hermit Hacker <scrappy@hub.org>, dg@illustra.com, miker@hub.org, hackers@postgreSQL.org
Date: 1998-06-30T04:20:02Z
Lists: pgsql-hackers 
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?

Lock for read...

Vadim