Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group