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

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Reindex and Vacuum togheter BUG ? [ was Vacuum bug ]
Date: 2003-05-07 09:03:34
Message-ID: b9ai5g$2u7g$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:22712(dot)1052198252(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "Gaetano Mendola" <mendola(at)bigfoot(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Hannu Krosing 2003-05-07 13:40:06 Re: An unresolved performance problem.
Previous Message Sean Chittenden 2003-05-07 05:23:54 float8 errors in HEAD...