pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jim C. Nasby <jim@nasby.net>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Mario Weilguni <mweilguni@sime.com>
Cc: pgsql-performance@postgresql.org, Alexander Staubo <alex@purefiction.net>
Cc: Ruben Rubio <ruben@rentalia.com>
Subject: Re: Optimization of this SQL sentence
Date: Wed, 18 Oct 2006 14:17:34 -0500
Message-ID: <20061018191734.GN85041@nasby.net> (raw)
In-Reply-To: <b42b73150610170951t33619da0u4851de1fbb1c0b0f@mail.gmail.com>
References: <45349CDF.3090002@rentalia.com>
	<4534A35E.9030909@rentalia.com>
	<181E6D21-8326-4ED6-A9AE-6F9917C1C319@purefiction.net>
	<200610171729.19596.mweilguni@sime.com>
	<b42b73150610170951t33619da0u4851de1fbb1c0b0f@mail.gmail.com>

On Tue, Oct 17, 2006 at 12:51:19PM -0400, Merlin Moncure wrote:
> so, imo alexander is correct:
> contacto varchar(255)
> 
> ...is a false constraint, why exactly 255? is that were the dart landed?

BTW, if we get variable-length varlena headers at some point, then
setting certain limits might make sense to keep performance more
consistent.
-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



view thread (24+ messages)  latest in thread

Message-ID: <20061018191734.GN85041@nasby.net>
Permalink:  ../20061018191734.GN85041@nasby.net/
Also on:    postgresql.org/message-id/20061018191734.GN85041@nasby.net

 · 

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: jim@nasby.net, mmoncure@gmail.com, mweilguni@sime.com, alex@purefiction.net, ruben@rentalia.com
  Subject: Re: Optimization of this SQL sentence
  In-Reply-To: <20061018191734.GN85041@nasby.net>

* 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