Re: measuring disk usage of records

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: cobalt(at)bearfruit(dot)org (Matthew Nuzum)
Cc: rovero(at)sonalysts(dot)com ("'P(dot)J(dot) \"Josh\" Rovero'"), pgsql-general(at)postgresql(dot)org
Subject: Re: measuring disk usage of records
Date: 2003-12-31 21:45:07
Message-ID: 200312312145.hBVLj7Mj019838@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message D. Dante Lorenso 2003-12-31 21:56:35 Re: website doc search is extremely SLOW
Previous Message Matthew Nuzum 2003-12-31 21:32:51 Re: measuring disk usage of records