Re: Best way to "add" columns

From: Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
To: Marten Feldtmann <marten(at)feki(dot)toppoint(dot)de>
Cc: Jesse Scott <jscott(at)bmi(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to "add" columns
Date: 2000-05-15 14:15:43
Message-ID: 3920068F.2FDF52F2@cupid.suninternet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marten Feldtmann wrote:
>
> The varable lengths columns should be at the end of the row, therefore
> it does not seem to be good to add an integer column after a varchar
> column.

1. Is this true? Should variable length column really be at the end
of a row?

2. If so, surly postgres can reorder tham internally so that on disk
they are in the optimal format.
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-05-15 14:15:53 Re: Dumping and reloading stuff in 6.5.3
Previous Message Martijn van Oosterhout 2000-05-15 14:12:25 Re: Dumping and reloading stuff in 6.5.3