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