Re: Field order - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Field order
Date
Msg-id 20050818015909.GA10684@wolff.to
Whole thread Raw
In response to Re: Field order  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
On Wed, Aug 17, 2005 at 17:40:34 -0500,
  "Jim C. Nasby" <jnasby@pervasive.com> wrote:
>
> Ugh, and here I'd been doing it the other way around. I assume
> variable-length stuff should always go last, right?

I think it depends on the alignment of the type. Certain text, char and varchar
should go at the end. Nullable columns also make a difference since there is
a shortcut used for rows that contain nulls.

pgsql-general by date:

Previous
From: "Michael Schmidt"
Date:
Subject: Re: Field order
Next
From: Kevin Murphy
Date:
Subject: Re: speeding up a query on a large table