Reindex and Vacuum togheter BUG ? [ was Vacuum bug ] - Mailing list pgsql-bugs

From Gaetano Mendola
Subject Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]
Date
Msg-id b972er$mfs$1@news.hub.org
Whole thread Raw
Responses Re: Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Wrong index usage in 7.3.2
Next
From: Tom Lane
Date:
Subject: Re: Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]