On Wed, Aug 31, 2005 at 10:59:49AM -0700, Jeff Frost wrote:
> Thanks Tom!
>
> Now what does the relpages column mean? I.e. how should I interpret that
> entry for my tables?
relpages is the number of "pages" of the table. A page is 8kb (unless
you changed a compile-time setting -- you can check it with SHOW
block_size).
Each page stores whole tuples, and can have some amount of free space.
Tuples exceeding a certain length will be "toasted", that is, some of
its attributes will be moved to an external table. Check the
documentation for more details -- there is a section called "Disk
Storage" or something similar.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"[PostgreSQL] is a great group; in my opinion it is THE best open source
development communities in existence anywhere." (Lamar Owen)