X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 92B993A5088 for ; Sat, 8 Jan 2005 03:49:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41294-03 for ; Sat, 8 Jan 2005 03:49:37 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 8E18E3A292C for ; Sat, 8 Jan 2005 03:49:44 +0000 (GMT) Received: (qmail 17591 invoked by uid 500); 8 Jan 2005 04:03:23 -0000 Date: Fri, 7 Jan 2005 22:03:23 -0600 From: Bruno Wolff III To: "Loren M. Lang" Cc: PostgreSQL Perfomance Subject: Re: TEXT field and Postgresql Perfomance Message-ID: <20050108040323.GA13889@wolff.to> Mail-Followup-To: "Loren M. Lang" , PostgreSQL Perfomance References: <20050108033647.GB2867@alzatex.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050108033647.GB2867@alzatex.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/87 X-Sequence-Number: 9777 On Fri, Jan 07, 2005 at 19:36:47 -0800, "Loren M. Lang" 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.