Re: table size in 8.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: table size in 8.3
Date
Msg-id 852.1205356832@sss.pgh.pa.us
Whole thread Raw
In response to table size in 8.3  (Alex Vinogradovs <AVinogradovs@clearpathnet.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: PostgreSQL won't start
Next
From: "Vyacheslav Kalinin"
Date:
Subject: Subplan and index usage