Re: Fixed width rows faster?

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Bill Moran <wmoran(at)potentialtech(dot)com>, Jeff <threshar(at)torgo(dot)978(dot)org>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Fixed width rows faster?
Date: 2004-03-05 23:54:04
Message-ID: 1078530843.57624.24.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-03-06 04:20:29 Re: Fixed width rows faster?
Previous Message Mike Nolan 2004-03-05 23:43:33 Re: Fixed width rows faster?