pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: Loren M. Lang <lorenl@alzatex.com>
Cc: PostgreSQL Perfomance <pgsql-performance@postgresql.org>
Subject: Re: TEXT field and Postgresql Perfomance
Date: Fri, 7 Jan 2005 22:03:23 -0600
Message-ID: <20050108040323.GA13889@wolff.to> (raw)
In-Reply-To: <20050108033647.GB2867@alzatex.com>
References: <20050108033647.GB2867@alzatex.com>

On Fri, Jan 07, 2005 at 19:36:47 -0800,
  "Loren M. Lang" <lorenl@alzatex.com> wrote:
> Do large TEXT or VARCHAR entries in postgresql cause any performance
> degradation when a query is being executed to search for data in a table
> where the TEXT/VARCHAR fields aren't being searched themselves?

Yes in that the data is more spread out because of the wider rows and that
results in more disk blocks being looked at to get the desired data.

> 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.



view thread (5+ messages)  latest in thread

Message-ID: <20050108040323.GA13889@wolff.to>
Permalink:  ../20050108040323.GA13889@wolff.to/
Also on:    postgresql.org/message-id/20050108040323.GA13889@wolff.to

 · 

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: bruno@wolff.to, lorenl@alzatex.com
  Subject: Re: TEXT field and Postgresql Perfomance
  In-Reply-To: <20050108040323.GA13889@wolff.to>

* 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