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"
