list all the Boolean flags in pg_class that are maintained lazily.

From: Jian He <hejian(dot)mark(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: list all the Boolean flags in pg_class that are maintained lazily.
Date: 2022-03-08 15:33:47
Message-ID: CAMV54g3sEbVfbQN7b0nT7Fgs-ummWhVVomX-y+NN8jw2=9YV9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2022-03-08 16:38:39 Re: Missing information about CREATE TRIGGER on temporary tables
Previous Message PG Doc comments form 2022-03-08 15:32:23 Missing information about CREATE TRIGGER on temporary tables