Size of tuples - Mailing list pgsql-general

From Alex Turner
Subject Size of tuples
Date
Msg-id 33c6269f0610091710l1d15e41ep5637420ba3b90bb4@mail.gmail.com
Whole thread Raw
Responses Re: Size of tuples  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
I have a table whose definition is basically

create table foo (
a int,
b int,
c int,
d date
);

and when fully populated, select relpages*8192::long/reltuples from pg_class where relname='foo';
gives around 52.  Why is it so wide when there are only 4*4=16 bytes of actual data?
The table was populated in one big go, and there have been 0 deletes or updates, althought I did do a few truncates, but I thought that basically zeroed everything?

Alex.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_autovacuum taking locks on multiple tables at the same time
Next
From: "George Pavlov"
Date:
Subject: Re: postgres query log analysis?