Re: [PERFORM] Physical column size

2006-01-26 Thread Mario Weilguni
Am Donnerstag, 26. Januar 2006 11:06 schrieb Paul Mackay: > Hi, > > I've created a table like this : > CREATE TABLE tmp_A ( > c "char", > i int4 > ); > > And another one > CREATE TABLE tmp_B ( > i int4, > ii int4 > ); > > I then inerted a bit more than 19 million rows in each table (exactly the > s

[PERFORM] Physical column size

2006-01-26 Thread Paul Mackay
Hi,I've created a table like this : CREATE TABLE tmp_A (c "char",i int4);And another one CREATE TABLE tmp_B (i int4,ii int4);I then inerted a bit more than 19 million rows in each table (exactly the same number of rows in each). The end result is that the physical size on disk used by table tmp_A