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