Re: [HACKERS] now 6.4 - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] now 6.4
Date
Msg-id 35986772.E9DA0D0C@krs.ru
Whole thread Raw
In response to Re: [HACKERS] now 6.4  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] now 6.4  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: new lock structure names
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] now 6.4