st 14. 7. 2021 v 7:42 odesílatel Laurenz Albe <laurenz.a...@cybertec.at> napsal:
> On Wed, 2021-07-14 at 14:05 +0900, Ian Lawrence Barwick wrote: > > 2021年7月14日(水) 12:07 Justin Pryzby <pry...@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)? > +1 good idea Pavel > Yours, > Laurenz Albe > > > >
