Postgres Pro
Downloads
Home   >   mailing lists

Thread: table size in 8.3

table size in 8.3

From
Alex Vinogradovs
Date:
Guys,

I've created 2 sample tables with 1 column each - type
char(1) and type integer. After inserting equal number
of rows (4M or more) tablesizes are exactly the same, while
I would expect table with char(1) to be slighly smaller...
What's causing it ? Thanks!

Server version is 8.3.


Best regards,
Alex Vinogradovs

Re: table size in 8.3

From
Tom Lane
Date:
Alex Vinogradovs <AVinogradovs@clearpathnet.com> writes:
> I've created 2 sample tables with 1 column each - type
> char(1) and type integer. After inserting equal number
> of rows (4M or more) tablesizes are exactly the same, while
> I would expect table with char(1) to be slighly smaller...
> What's causing it ? Thanks!

Alignment padding ... rows are always padded out to a MAXALIGN multiple.

            regards, tom lane