Re: Help:How do you find that how much storage is taken by the database??

From: Sevo Stille <sevo(at)ip23(dot)net>
To: Ron Peterson <rpeterson(at)yellowbank(dot)com>
Cc: NEERAJ BANSAL <nbansal1(at)email(dot)mot(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Help:How do you find that how much storage is taken by the database??
Date: 2000-06-21 14:19:29
Message-ID: 3950CEF1.23015169@ip23.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Peterson wrote:
>
> NEERAJ BANSAL wrote:
> >
> > Hi,
> >
> > How do you find that how much storage the data in the database or tables
> > is taking in bytes or any other format???
> > Is there any command which tells you this???
>
> ls -l /usr/local/pgsql/data/base

Which would give you the size of the directories, not the disk usage of
their content. Make that du -sk /usr/local/pgsql/data/base/*

Sevo

--
sevo(at)ip23(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Britten 2000-06-21 15:40:15 boolean isn't boolean?
Previous Message Martijn van Oosterhout 2000-06-21 14:16:24 Limits in subqueries...