various questions on column sizes & cleaning up

From: charette(at)writeme(dot)com (Stephane Charette)
To: pgsql-general(at)postgresql(dot)org
Subject: various questions on column sizes & cleaning up
Date: 2003-03-19 22:09:06
Message-ID: 1be4bb40.0303191409.3203e5a0@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We've inherited another linux postgres database project with many
tables. We're trying to get a better understanding of the physical
disk space properties and requirements for this database.

(Nice trick: running "select relname, relfilenode from pg_class where
relname not like 'pg%' order by relfilenode;" helped us determine
which table and index maps to which physical file.)

My questions:

- Is there a SQL command I can run to determine the actual size of a
row within a table? (Or the byte sizes of each individual columns?)

- Is there a listing of the column types and the number of bytes
required?

- Does running vacuum clean up the indexes as well as tables?

- Or is there a different command we should also run for the indexes?

- Or is nothing necessary for the indexes?

Thanks in advance!

Stephane Charette

Browse pgsql-general by date

  From Date Subject
Next Message Paul M Foster 2003-03-19 23:14:24 Multiple backend connections
Previous Message Liu, Mingyi 2003-03-19 21:44:48