Re: [GENERAL] vacuum error "left link changed unexpectedly"

[Ulrich Wisser]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org