Re: [HACKERS] now 6.4

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