Re: Disk usage

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, shridhar_daithankar(at)persistent(dot)co(dot)in, pgsql-general(at)postgresql(dot)org
Subject: Re: Disk usage
Date: 2003-05-08 19:57:56
Message-ID: 200305081957.h48Jvu518966@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera wrote:
> On Thu, May 08, 2003 at 10:39:48AM -0400, Tom Lane wrote:
>
> > Or do
> >
> > vacuum;
> > select relname, relpages * 8 from pg_class;
> >
> > to get table sizes in kilobytes. relpages is not updated on-the-fly,
> > only by vacuum, so you need to have done vacuum recently to get
> > trustworthy numbers.
>
> Doesn't ANALYZE update relpages values?

Yes, vacuum and analyze do it. There is a 'monitoring disk space'
section in the 7.3 docs too.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jon Earle 2003-05-08 19:58:41 Error installing postgresql-7.3.2 (fixed, but Q remains...)
Previous Message Alvaro Herrera 2003-05-08 19:46:36 Re: Disk usage