Re: Fixed width rows faster?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Jain" <Eric(dot)Jain(at)isb-sib(dot)ch>
Cc: "pgsql-performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Fixed width rows faster?
Date: 2004-03-06 20:52:26
Message-ID: 18296.1078606346@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Eric Jain" <Eric(dot)Jain(at)isb-sib(dot)ch> writes:
> The main reason why I am still using VARCHAR rather than TEXT in many
> places is to ensure that the column can be indexed. Postgres, it seems,
> refuses to insert a string that is longer than some value into an
> indexed column, and I'll rather have such errors flagged while inserting
> a row rather than while rebuilding an index after having inserted lots
> of rows.

This is bogus reasoning. The limit on index entry length will not
change when you rebuild the index.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-03-06 21:06:09 Re: Feature request: smarter use of conditional indexes
Previous Message John Siracusa 2004-03-06 20:51:47 Re: Feature request: smarter use of conditional indexes