table size in 8.3
Started by Alex Vinogradovsabout 18 years ago2 messagesgeneral
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
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