Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]
Date: 2003-05-06 01:16:28
Message-ID: b972er$mfs$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-05-06 05:17:32 Re: Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]
Previous Message Achilleus Mantzios 2003-05-05 12:27:41 Wrong index usage in 7.3.2