Re: alter table drop column status

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, "Kovacs Zoltan" <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: alter table drop column status
Date: 2002-02-15 17:13:14
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA41EB4FC@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> Another objection is the need to add an OID field to tuple headers; 4
> more bytes per tuple adds up (and on some platforms it'd be 8 bytes due
> to alignment considerations).

How about only allowing one version per page, this is how Informix does it.
Imho separating in memory tuple representation from on disk tuple representation
would be a good thing anyway. While you need to align certain things in memory
there is no need to align on disk stuff. This would potentially save a lot of
diskspace. I know a lot of people say disk space is cheap, but the issue is that
IO is slow. It would also open the door to features like compressing datapages
like RDB does. We have calculated here that porting six ~750 Gb databases from
rdb to some other db would need ~4 times the disk space.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB SD 2002-02-15 17:18:35 Re: "Bug" in statistics for v7.2?
Previous Message Tom Lane 2002-02-15 16:02:27 Re: Ready to branch 7.2/7.3 ?