table size in 8.3

From: Alex Vinogradovs <AVinogradovs(at)clearpathnet(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: table size in 8.3
Date: 2008-03-12 19:45:55
Message-ID: 1205351155.72532.5.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Potts 2008-03-12 19:46:24 Re: pain of postgres upgrade with extensions
Previous Message Pavel Stehule 2008-03-12 19:45:47 Re: PostgreSQL user documentation wiki open for business