Skip site navigation (1) Skip section navigation (2)

Re: Does pgsql database (file) size increases automatically as we put data?

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: leela <its_leela(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Does pgsql database (file) size increases automatically as we put data?
Date: 2009-10-19 14:52:58
Message-ID: 4ec1cf760910190752q1256ce8u3eebbdc8a1a4d5cd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, Oct 19, 2009 at 6:33 AM, leela <its_leela(at)yahoo(dot)com> wrote:
>
> I have a basic query about the FILE SIZE of database file..
>
> Does pgsql database (file) size increases automatically as we put data or are there any things specific which we do during installation that restricts file size, etc?

Here's a query that will show how much disk space is being used by the
tables and indexes in a given schema. Just substitute your schema name
for 'your_schema_name'.

select relname, pg_size_pretty( pg_relation_size( oid ) ) AS size_alone,
  pg_size_pretty( pg_total_relation_size( oid ) ) AS total_size_incl_indexes
from pg_class where relnamespace =
  ( select oid from pg_namespace where nspname = 'your_schema_name')
order by pg_relation_size( oid ) desc;

You might also want to keep an eye on how much disk space is being
consumed by your PGDATA directory if you're worried about running out
of space.

 Josh

In response to

Responses

pgsql-novice by date

Next:From: Eric ComeauDate: 2009-10-20 12:34:14
Subject: Re: Does pgsql database (file) size increases automatically as we put data?
Previous:From: Michael SwierczekDate: 2009-10-19 13:04:29
Subject: Re: Does pgsql database (file) size increases automatically as we put data?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group