Re: resolving buffer busy waits

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Thu, 18 Sep 2003 13:12:19 +0300
Message-ID: <3f698504$1_1@news.estpak.ee>

> I think this means you are using a non-unique index, is there any way
> you can add a unique one? A whole bunch of people trying to do the
> same thing might show your cyclical symptoms, since they each have to
> wait for many blocks to be available which they might not even care
> about. The cycle might be shortened noticeably if you can change it
> to index unique scan.

It should be enough if you have an unique constraint on column, the index itself can be nonunique.

Tanel. Received on Thu Sep 18 2003 - 05:12:19 CDT