Re: Case Insensitive Queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark <mark(at)zserve(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Case Insensitive Queries
Date: 2001-05-30 20:45:09
Message-ID: 4704.991255509@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mark <mark(at)zserve(dot)com> writes:
> Even the postgresql documentation asserts something similar to this:

You're reading obsolete documentation. There is no such assertion
(as far as I can find, anyway) in the 7.1 documentation. The speed
advantage of bpchar --- which was always extremely marginal anyway,
if it was real at all when you consider I/O costs --- is gone completely
now, because with TOAST in the picture the system cannot assume that
bpchar is fixed length on disk.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Contrepois 2001-05-30 21:21:50 Re: Slow inserts/deletes
Previous Message Chris Ruprecht 2001-05-30 20:14:17 Unique record Identifier?