Re: vacuum error "left link changed unexpectedly" - Mailing list pgsql-general

From Ulrich Wisser
Subject Re: vacuum error "left link changed unexpectedly"
Date
Msg-id 430195BE.1050007@relevanttraffic.se
Whole thread Raw
In response to Re: vacuum error "left link changed unexpectedly"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: vacuum error "left link changed unexpectedly"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi Tom,

> No, it would be the one next to be processed.  VACUUM does them in OID
> order, so try something like
>
>     select indexrelid::regclass from pg_index
>     where indrelid = 'public.userclick'::regclass
>     order by indexrelid;

   indexrelid
---------------
  userclick_i01
  userclick_i02
  userclick_i03
  userclick_i04
  userclick_i05
  userclick_i06
  userclick_i07
(7 rows)

How do I proceed? How can I tell which files are involved?

Regards,

Ulrich


--
Ulrich Wisser  / System Developer

RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
________________________________________________________________
http://www.relevanttraffic.com

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: 5 new entries for FAQ
Next
From: "Magnus Hagander"
Date:
Subject: Re: libpy and ENABLE_THREAD_SAFETY=1