From: | Peter Geoghegan <pg(at)heroku(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 9.5 release notes |
Date: | 2015-06-14 21:08:17 |
Message-ID: | CAM3SWZTcgpXkeHqZr4gaC2icSfa74eTvnkg_N4nj+XAztVoiTQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sat, Jun 13, 2015 at 6:24 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>> I think we should really address this. Attached patch adds a new
>> release note item for it. It also adds to the documentation that
>> explains why users should prefer varchar(n)/text to character(n); the
>> lack of abbreviated key support now becomes a huge disadvantage for
>> character(n), whereas in previous versions the disadvantages were
>> fairly minor.
>>
>> In passing, I updated the existing sort item to reflect that only
>> varchar(n), text, and numeric benefit from the abbreviation
>> optimization (not character types more generally + numeric), and added
>> a note on the effectiveness of the abbreviation optimization alone.
>
> This all also seems like overkill to me. Users just don't care about
> this level of detail, and are easily confused by it.
Really? The pre-check thing wasn't too complex for Magnus to have a
couple of bullet points on it *specifically* in his high level NYC
talk on Postgres 9.5 features [1]. I don't think it's hard to
understand at all.
Also, it's simply incorrect to describe abbreviation as: "Improve the
speed of sorting character and numeric fields". Character fields
presumably include character(n), and as I pointed out character(n)
lacks abbreviation support. That needs to be documented as an
additional disadvantage of character(n) vs text/varchar(n) in the
documentation where the trade-off is already discussed (i.e. not in
the release notes), because it makes a *huge* difference. And ISTM
that it should also be clear from the release notes themselves. We
seemingly always have <type> </type> tags when types are named in
release notes.
[1] http://www.hagander.net/talks/postgresql95.pdf
--
Peter Geoghegan
From | Date | Subject | |
---|---|---|---|
Next Message | Jan de Visser | 2015-06-14 22:16:10 | Re: Git humor |
Previous Message | Tom Lane | 2015-06-14 20:21:15 | Re: Memory Accounting v11 |