You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.
A number of people have reported (#6696) database index corruption which basically stems from their databases having a UTF-8 collation setting.
Our documentation tells you to set the collation to "C" to avoid this sort of thing (and possibly improve performance, according to postgres-general), but this is little comfort to people who missed that advice and now have corrupt indexes to deal with.
By way of a preventative measure, maybe we should complain if somebody is using a different collation?
synapse=# SELECT datcollate FROM pg_database WHERE datname = current_database();
datcollate
------------
C
(1 row)
The text was updated successfully, but these errors were encountered:
A number of people have reported (#6696) database index corruption which basically stems from their databases having a UTF-8 collation setting.
Our documentation tells you to set the collation to "C" to avoid this sort of thing (and possibly improve performance, according to postgres-general), but this is little comfort to people who missed that advice and now have corrupt indexes to deal with.
By way of a preventative measure, maybe we should complain if somebody is using a different collation?
The text was updated successfully, but these errors were encountered: