The following bug has been logged online:
Bug reference: 4238
Logged by: Lawrence Cohan
Email address: lawrencec@1shoppingcart.com
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.