On Thu, Mar 31, 2016 at 3:52 PM, Magnus Hagander <magnus@hagander.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:
