From: | Larry Rosenman <Larry(dot)Rosenman(at)pervasive(dot)com> |
---|---|
To: | Yumiko Izumi <izumi-yumiko(at)scnet(dot)co(dot)jp> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: We want to monitor total size of database |
Date: | 2005-12-28 14:00:11 |
Message-ID: | E1Erbqd-0003gs-H2@lerami.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Dec 27 2005, Yumiko Izumi wrote:
> Hello.
>
> We want to monitor the following items with respect to PostgreSQL.
> *Total Size of database
> *Size of used space of the entire database
> *Size of free space of the entire database
> *Size of fragmentation area of the entire database
>
> But the following items are getting monitored in PostgreSQL7.3.8.
> ("Pgstattuple" is used for monitoring)
> *Total of sizes of all the tables in database
> *Total of used space by all the tables in database
> *Total of free space of all the tables in database
> *Total of fragmentation area of all the tables in database
>
> In short, in 7.3.8 we are not able to acquire the information on the
> space related to index but the information of the partial area of the
> database is monitored.
>
> Therefore, we are in search of the method to monitor the space of the
> entire database.
>
> Our question is: Is there any method available in PostgreSQL8.1.0 for
> monitoring the space of the entire database ?
I believe that the pgstat* functions were improved in 8.1 to include
this information.
--
Larry Rosenman, Database Support Engineer, E-Mail:
Larry(dot)Rosenman(at)pervasive(dot)com Pervasive Software, 12365B Riata Trace
Parkway, Austin, TX 78727 Office: 512-231-6173
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-12-28 14:22:04 | Re: We want to monitor total size of database |
Previous Message | Kevin Crenshaw | 2005-12-28 12:15:36 | Re: Complex Query Help- For Me, Anyway |