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