Re: measuring disk usage of records - Mailing list pgsql-general

From Mike Nolan
Subject Re: measuring disk usage of records
Date
Msg-id 200312312145.hBVLj7Mj019838@gw.tssi.com
Whole thread Raw
In response to Re: measuring disk usage of records  ("Matthew Nuzum" <cobalt@bearfruit.org>)
Responses Re: measuring disk usage of records  (Kris Jurka <books@ejurka.com>)
List pgsql-general
> Thanks for the very quick reply... I didn't know about the dbsize stuff,
> they may help. Unfortunately, the records are mixed together.

If user tables are grouped by schema, you should be able to pull the
dbsize data by schema.

That raises an interesting question.  Can pg be configured so
that user tables MUST be in user schemas, i.e., nobody can put tables
in the PUBLIC schema?
--
Mike Nolan

pgsql-general by date:

Previous
From: "Matthew Nuzum"
Date:
Subject: Re: measuring disk usage of records
Next
From: "Marc G. Fournier"
Date:
Subject: Re: website doc search is extremely SLOW