Re: frustration with database size <long>

From: "Thomas F(dot) O'Connell" <tfo(at)monsterlabs(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: frustration with database size <long>
Date: 2002-01-21 20:40:08
Message-ID: 3C4C7CA8.8080005@monsterlabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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.

thanks!

-tfo

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ned Wolpert 2002-01-21 20:41:46 Re: [GENERAL] PostgreSQL Licence: GNU/GPL
Previous Message Philip Hallstrom 2002-01-21 20:39:11 Re: [HACKERS] PostgreSQL Licence: GNU/GPL