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
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 ??!! |
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 |