Re: VACUUM failing ??!!

From: "Salem Berhanu" <salemb4(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us, dedeb17(at)hotmail(dot)com
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM failing ??!!
Date: 2004-11-05 17:19:15
Message-ID: BAY16-F10PRPAMeE6TR00012f09@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Version 7.4
(I just re-indexed and I'm running vacuum again)

>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Sally Sally" <dedeb17(at)hotmail(dot)com>
>CC: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
>Subject: Re: [ADMIN] VACUUM failing ??!! Date: Fri, 05 Nov 2004 11:04:00
>-0500
>
>"Sally Sally" <dedeb17(at)hotmail(dot)com> writes:
> > After running for more than 24 hrs (I have a large db), vacuum failed
>with
> > this message:
> > ERROR: failed to re-find parent key in "pg_type_typname_nsp_index"
>
>What PG version?
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message danda 2004-11-05 19:37:33 dump/restore results in duplicate key violation with 7.4.6. Bug?
Previous Message Tom Lane 2004-11-05 16:04:00 Re: VACUUM failing ??!!

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F.O'Connell 2004-11-05 18:24:23 Re: create a text file from postgres (like Oracle UTL_FILE package)
Previous Message Mario A. Soto Cordones 2004-11-05 17:18:03 Trigger Parameter problem