| From: | Bhakti Ghatkar <bghatkar(at)zedo(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Error while vacuuming |
| Date: | 2011-11-08 06:33:21 |
| Message-ID: | CAJeA4QGAHzo=6Y6W_GDfEBW+C5zYObJXxXcuVw2f7mbda9jBHA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Tom,
Currently we are using version 9.0.1.
Which version shall we update to? 9.05 or 9.1 ?
~Bhakti
On Fri, Nov 4, 2011 at 7:44 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bhakti Ghatkar <bghatkar(at)zedo(dot)com> writes:
> > Hi ,
> > While performing full vacuum we encountered the error below:
>
>
> > INFO: vacuuming "pg_catalog.pg_index"
> > vacuumdb: vacuuming of database "xxxx" failed: ERROR: duplicate key
> value
> > violates unique constraint "ccccc"
> > DETAIL: Key (indexrelid)=(2678) already exists.
>
> > We are using Postgres 9.0.1
>
> > Can you please help us out in understanding the cause of this error?
>
> Try updating ... that looks suspiciously like a bug that was fixed a few
> months ago.
>
> regards, tom lane
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Gendler | 2011-11-08 07:19:08 | Re: Performance Problem with postgresql 9.03, 8GB RAM, Quadcore Processor Server--Need help!!!!!!! |
| Previous Message | Mohamed Hashim | 2011-11-08 03:21:35 | Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! |