The following bug has been logged online: Bug reference: 4238 Logged by: Lawrence Cohan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Linux 4.1.1 Description: pg_class.relhasindex not updated by vacuum Details:
We rely on this column to build a list of tables restricted to only those that have indexes to be rebuilt with CONCURRENTLY however the column is not updated as documentation says by the vacuum. After a successful analyze/vacuum/analyze against the entire database ALL tables from pg_class have the pg_class.relhasindex = true even if they don't have any indexes. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs