| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | pgsql-announce <pgsql-announce(at)postgresql(dot)org> |
| Subject: | Re: 2016-03-31 Security Update Release |
| Date: | 2016-03-31 14:43:01 |
| Message-ID: | CABUevExnttXKvaeFqFRn__HPxrjyhmTo0kQ1L_X8a0f3jkdaFg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce |
On Thu, Mar 31, 2016 at 3:52 PM, Magnus Hagander <magnus(at)hagander(dot)net>
wrote:
> Abbreviated Keys and Corrupt Indexes
> ------------------------------------
>
> In this release, the PostgreSQL Project has been forced to disable 9.5's Abbreviated Keys performance feature for many indexes due to reports of index corruption. This may affect any B-tree indexes on TEXT, VARCHAR, and CHAR columns which are not in "C" locale. Indexes in other locales will lose the performance benefits of the feature, and should be REINDEXed in case of existing index corruption. The feature may be re-enabled in future versions if the project finds a solution for the problem. See the release notes, and the wiki page on this issue for more information: http://wiki.postgresql.org/abbreviatedkeys_issue
>
>
Unfortunately this link ended up being wrong. The correct link is:
https://wiki.postgresql.org/wiki/Abbreviatedkeys_issue
My apologies for that!
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2016-04-04 00:05:14 | == PostgreSQL Weekly News - April 03 2016 == |
| Previous Message | Magnus Hagander | 2016-03-31 13:52:46 | 2016-03-31 Security Update Release |