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@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
