public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jian He <[email protected]>
To: [email protected]
Subject: list all the Boolean flags in pg_class that are maintained lazily.
Date: Tue, 8 Mar 2022 21:03:47 +0530
Message-ID: <CAMV54g3sEbVfbQN7b0nT7Fgs-ummWhVVomX-y+NN8jw2=9YV9w@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: list all the Boolean flags in pg_class that are maintained lazily.
In-Reply-To: <CAMV54g3sEbVfbQN7b0nT7Fgs-ummWhVVomX-y+NN8jw2=9YV9w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox