thanks tom. i wasn't sure about create index taking
exclusive locks on tables too. so i could as well
reindex than doing the whole _swap mess during
off-peak hrs.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Shankar K <[EMAIL PROTECTED]> writes:
> > ... so i then decided to do reindex online, but
>
Shankar K <[EMAIL PROTECTED]> writes:
> ... so i then decided to do reindex online, but
> that makes exclusive lock on table which would prevent
> writing on to tables.
So does CREATE INDEX, so it's not clear what you're buying with
all these pushups.
> 2. analyze table to update stats, so that t
