Re: [PERFORM] Error while vacuuming

2011-11-07 Thread Bhakti Ghatkar
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 wrote: > Bhakti Ghatkar writes: > > Hi , > > While performing full vacuum we encountered the error below: > > > > INFO: vac

[PERFORM] Error while vacuuming

2011-11-04 Thread Bhakti Ghatkar
Hi , While performing full vacuum we encountered the error below: INFO: vacuuming "pg_catalog.pg_index" vacuumdb: vacuuming of database "" failed: ERROR: duplicate key value violates unique constraint "c" DETAIL: Key (indexrelid)=(2678) already exists. We are using Postgres 9.0.1 Ca

Re: [PERFORM] Vacuum problem due to temp tables

2011-02-27 Thread Bhakti Ghatkar
Tom, The query which you gave returns me 0 rows. select ctid,xmin,xmax,* from pg_index where indexrelid in (select indexrelid from pg_index group by 1 having count(*)>1); Regards, Bhakti On Sat, Feb 26, 2011 at 10:55 PM, Tom Lane wrote: > Bhakti Ghatkar writes: > > We

[PERFORM] Vacuum problem due to temp tables

2011-02-25 Thread Bhakti Ghatkar
Hi, We were running full vacuum on DB when we encountered the error below; INFO: analyzing "public.bkup_access_control" INFO: "bkup_access_control": scanned 14420 of 14420 pages, containing 1634113 live rows and 0 dead rows; 3 rows in sample, 1634113 estimated total rows INFO: vacuuming "p