PostgreSQL: Documentation: 14: 52.11. pg_class
<https://www.postgresql.org/docs/current/catalog-pg-class.html>

> Several of the Boolean flags in pg_class are maintained lazily: they are
> guaranteed to be true if that's the correct state, but may not be reset to
> false immediately when the condition is no longer true. For example,
> relhasindex is set by CREATE INDEX
> <https://www.postgresql.org/docs/current/sql-createindex.html>, but it is
> never cleared by DROP INDEX
> <https://www.postgresql.org/docs/current/sql-dropindex.html>. Instead,
> VACUUM <https://www.postgresql.org/docs/current/sql-vacuum.html> clears
> relhasindex if it finds the table has no indexes. This arrangement avoids
> race conditions and improves concurrency.


9 boolean flags, 1 already mentioned  maintained lazily.
Is possible to list all the flags that maintained  lazily. or just mention This
is only an estimate like *relpage *flags in the same page.

Reply via email to