[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] auto vacuum settings
From:       Alvaro Herrera <alvherre () alvh ! no-ip ! org>
Date:       2005-08-31 18:07:03
Message-ID: 20050831180703.GA23453 () surnet ! cl
[Download RAW message or body]

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)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic