On Wed, 2021-07-14 at 14:05 +0900, Ian Lawrence Barwick wrote: > 2021年7月14日(水) 12:07 Justin Pryzby <pryzby@telsasoft.com>: > > \db+ and \l+ show sizes of tablespaces and databases, so I was surprised in the > > past that \dn+ didn't show sizes of schemas. I would find that somewhat > > convenient, and I assume other people would use it even more useful. > > It's something which would be useful to have. But see this previous proposal: > > https://www.postgresql.org/message-id/flat/2d6d2ebf-4dbc-4f74-17d8-05461f4782e2%40dalibo.com
Right, I would not like to cause a lot of I/O activity just to look at the permissions on a schema...
Besides, schemas are not physical, but logical containers. So I see a point in measuring the storage used in a certain tablespace, but not so much by all objects in a certain schema. It might be useful for accounting purposes, though. But I don't expect it to be in frequent enough demand to add a psql command.
What about inventing a function pg_schema_size(regnamespace)?