Re: B-tree index on a VARCHAR(4000) column

From: John Turner <fenwayriffs(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: B-tree index on a VARCHAR(4000) column
Date: 2017-09-10 19:12:13
Message-ID: CAMAP1QmyPMCW8i5s4z0CBpnd--OrBkhU_pNVxjfBXB5udjhRyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Sep 10, 2017 at 1:24 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>
> For every other purpose, PG just pays attention to the actual column
> values' lengths.
>
> Thanks for elaborating, Tom. This would appear to be a(nother) case where
PG represents the voice of sanity as compared with 'the other guys' : )

John

In response to

Browse pgsql-general by date

  From Date Subject
Next Message techmail+pgsql 2017-09-10 20:54:45 Re: pg_ident mapping Kerberos Usernames
Previous Message techmail+pgsql 2017-09-10 18:25:45 Re: pg_ident mapping Kerberos Usernames