pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Fuhr <mike@fuhr.org>
To: Loren M. Lang <lorenl@alzatex.com>
To: PostgreSQL Perfomance <pgsql-performance@postgresql.org>
Subject: Re: TEXT field and Postgresql Perfomance
Date: Fri, 7 Jan 2005 22:23:13 -0700
Message-ID: <20050108052313.GA3509@winnie.fuhr.org> (raw)
In-Reply-To: <20050108040323.GA13889@wolff.to>
References: <20050108033647.GB2867@alzatex.com>
	<20050108040323.GA13889@wolff.to>

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" <lorenl@alzatex.com> 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
http://www.fuhr.org/~mfuhr/



view thread (5+ messages)  latest in thread

Message-ID: <20050108052313.GA3509@winnie.fuhr.org>
Permalink:  ../20050108052313.GA3509@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20050108052313.GA3509@winnie.fuhr.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mike@fuhr.org, lorenl@alzatex.com
  Subject: Re: TEXT field and Postgresql Perfomance
  In-Reply-To: <20050108052313.GA3509@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox