Re: using index "pg_toast_..." despite IgnoreSystemIndexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lsq(at)nym(dot)hush(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: using index "pg_toast_..." despite IgnoreSystemIndexes
Date: 2012-08-28 16:24:42
Message-ID: 2570.1346171082@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

lsq(at)nym(dot)hush(dot)com writes:
> After an upgrade to 8.4.12 from 8.4.10 we vacuum/analyzed the db.
> Postgres is running in standalone mode at this point.

Why were you using standalone mode? And why were you using
ignore_system_indexes? This whole procedure seems like overkill
for a routine minor-version update.

> 07/31/12 04:09:57 WARNING: using index "pg_toast_2619_index"
> despite IgnoreSystemIndexes

> I see the warning generated in systable_beginscan_ordered as a
> warning, and then it proceeds to do the work anyway.
> It appears as if this is benign. Is that the case?

It is unless you have some reason to think that that index is corrupt...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Shira Bezalel 2012-08-28 22:31:21 question about logging_collector
Previous Message Merlin Moncure 2012-08-28 13:51:41 Re: pgpool