Thread: Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]

Some days ago I posted the fact that aftter a vacuum
I got a primary key duplicated, after investigation I realize that
may be was a  reindex on that table? I do almost 50 ( in a day )
vacuum analyze of entire DB e other 300 (in a day ) vacuum full of
particular tables.
Each morning at 07:10 AM I do a big db_purge with a reindex of
some tables ( the table with the duplicate key too ) and if this
operation take longs at 7:15 AM there are a reindex and a vacuum
analize that are running at the same time, may be this can be the
source of my problems ?

Regards
Gaetano

"Gaetano Mendola" <mendola@bigfoot.com> writes:
> there are a reindex and a vacuum
> analize that are running at the same time, may be this can be the
> source of my problems ?

Seems unlikely.  REINDEX will take an exclusive lock on the table it's
working on.

            regards, tom lane

"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:22712.1052198252@sss.pgh.pa.us...
> "Gaetano Mendola" <mendola@bigfoot.com> writes:
> > there are a reindex and a vacuum
> > analize that are running at the same time, may be this can be the
> > source of my problems ?
>
> Seems unlikely.  REINDEX will take an exclusive lock on the table it's
> working on.

Yes, I agree, but you know some critical race... anyway any clue about
this problem with duplicate primary key ? Is it not possible enforce the
control somewhere ?


Regards
Gaetano