Yang Zhang writes:
> We're trying to figure out how to account for our disk space
> consumption in a database.
> $ sudo du -shx /var/lib/postgresql/8.4/main/
> 1.9G/var/lib/postgresql/8.4/main/
> But when we query Postgresql to find out how much disk space is
> actually being used by the var
We're trying to figure out how to account for our disk space
consumption in a database.
$ sudo du -shx /var/lib/postgresql/8.4/main/
1.9G/var/lib/postgresql/8.4/main/
But when we query Postgresql to find out how much disk space is
actually being used by the various databases, we get a total o
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Steve Crawford
> Sent: Monday, March 28, 2011 12:22 PM
> To: Yang Zhang
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Disk space us
On 03/25/2011 07:58 PM, Yang Zhang wrote:
Is there any tool for breaking down how much disk space is used by
(could be freed by removing) various tables, indexes, selected rows,
etc.? Thanks!
You can use the pg_class table and the pg_relation_size (and optionally
the pg_size_pretty) function
Is there any tool for breaking down how much disk space is used by
(could be freed by removing) various tables, indexes, selected rows,
etc.? Thanks!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgs
I w'd like to know how the DB growth impacts the actual disk
space. For example, I have a table with one textfield,
char(20) and I insert 100 records. My DB size w'd
be approximately,
20+28(Overhead)=48*100=48MB. What is the actual
effect on the physical HDD. I w'd appreciate your
help.
Th
