On Fri, Jan 07, 2005 at 10:03:23PM -0600, Bruno Wolff III wrote:
> On Fri, Jan 07, 2005 at 19:36:47 -0800, "Loren M. Lang" <[EMAIL PROTECTED]> 
> wrote:
> > Since, according to the postgresql docs, theirs no performance
> > difference between VARCHAR and TEXT, I'm assuming VARCHAR is identical
> > to TEXT entries with a restriction set on the length.  And since TEXT
> > can be of any possible size, then they must be stored independently of
> No.
> > the rest of the table which is probably all stored in a fixed size rows
> No, Postgres uses variable length records.

A discussion of TOAST and ALTER TABLE SET STORAGE might be appropriate
here, but I'll defer that to somebody who understands such things
better than me.

Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to