Re: Fixed width rows faster? - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Fixed width rows faster?
Date
Msg-id 1078530843.57624.24.camel@jester
Whole thread Raw
In response to Re: Fixed width rows faster?  (Mike Nolan <nolan@gw.tssi.com>)
Responses Re: Fixed width rows faster?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: Fixed width rows faster?  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-performance
On Fri, 2004-03-05 at 18:43, Mike Nolan wrote:
> > Frankly, the only reason to use anything other than TEXT is compatibility with
> > other databases and applications.
>
> You don't consider a requirement that a field be no longer than a
> certain length a reason not to use TEXT?

Actually, I don't. Good reason to have a check constraint on it though
(hint, check constraints can be changed while column types cannot be, at
this moment).


pgsql-performance by date:

Previous
From: Mike Nolan
Date:
Subject: Re: Fixed width rows faster?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Fixed width rows faster?