Re: Disk usage

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?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"God is real, unless declared as int"