Size of tuples

Поиск
Список
Период
Сортировка
От Alex Turner
Тема Size of tuples
Дата
Msg-id 33c6269f0610091710l1d15e41ep5637420ba3b90bb4@mail.gmail.com
обсуждение исходный текст
Ответы Re: Size of tuples  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_autovacuum taking locks on multiple tables at the same time
Следующее
От: "George Pavlov"
Дата:
Сообщение: Re: postgres query log analysis?