Re: frustration with database size

On 21.01.02 14:40 -0600(+0000), Thomas F. O'Connell wrote:
> >An easy way to get some data is to do a VACUUM so that the relpages
> >statistics are up to date, and then do
> >
> >select relname,relkind,relpages from pg_class order by relpages desc;
>
>
> well, that certainly is data. but what does it mean?
> what does this query actually spell out?
> to what do relkind and relpages refere?
> just curious.
>
It's documented in the developers guide:
http://www.postgresql.org/idocs/index.php?catalog-pg-class.html

relname         Name of the table, index, view, etc.
relkind         'r'=ordinary table,'i'=index,'S'=sequence,'v'=view,
                's'=special,'t'=secondary TOAST table
relpages        Size of the on-disk representation of this table in pages
                (size BLCKSZ).  This is only an approximate value
                   which is calculated during vacuum.

- Einar Karttunen