Re: Problems during doing reindex on 7.0.3

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Denis Perchine <dyp(at)perchine(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems during doing reindex on 7.0.3
Date: 2000-11-14 01:33:56
Message-ID: 3A109684.E508B1F1@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Denis Perchine wrote:
>
> Hello,
>
> I have very interesting problem. I have quite highly loaded database.
> Once a day I create new indices, and after that drop old ones. Ido this one
> by one.
>

Your "reindex" is different from REINDEX command,isn't it ?

> All is fine except this error message I sometimes get for some of the queries
> just after reindex.
>
> ERROR: Index 2050642 does not exist
>
> Looks like index oid was already resolved, but index was not locked yet...
> And it was dropped just under the feet...
>

Parser-rewriter-planner acquires a short term lock.
This may be improved in 7.1 though I'm not sure.

Regards.
Hiroshi Inoue

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edward Q. Bridges 2000-11-14 01:40:53 Is this proper UNION behavior??
Previous Message Edward Q. Bridges 2000-11-14 01:27:48 Is this proper UNION behavior??