#Collate copies meaning how to

Outside special technical fields, it may be better known as an old fashioned and formal name for a cold meal (cf. Book binders use it to mean putting pages into the correct order. The term derives from a form of the Latin verb conferre meaning to confer, bring together, or compare. Plus, you’ll get a bit of background on collations, too. In this article I’ll talk about the problem we need to solve-that PostgreSQL indexes can get corrupted by changes in collations that occur naturally over time-and how the new feature will make things better in a future version of PostgreSQL. Reviewed-by: Peter Eisentraut (earlier versions) Michael Paquier, Robert Haas, Tom Lane and others for very helpful

Thanks to Douglas Doole, Peter Eisentraut, Christoph Berg, Laurenz Albe, That the index may be corrupted if the current version doesn't match. Record the current version of dependent collations in pg_depend whenĬreating or rebuilding an index. It was originally planned for PostgreSQL 14, but some unhandled complications arose so this project is back in the workshop.Ĭommit 257836a75585934cc05ed7a80bccf8190d41e056

#Collate copies meaning how to

It’s taken a long time to build a consensus on how to tackle this thorny problem (work I began at EnterpriseDB and continued at Microsoft), and you can read about some of the details and considerations in the commit message below and the referenced discussion thread. The feature discussed is now a candidate for PostgreSQL 15 and the text has been updated to reflect this.Īs part of my work on the open source PostgreSQL team at Microsoft, I’ve been developing a new feature for PostgreSQL to track dependencies on collation versions, with help from co-author Julien Rouhaud and many others who have contributed ideas. : This blog post was originally written during the PostgreSQL 14 development cycle. This post by Postgres committer Thomas Munro about collation versioning was originally published on the Azure Database for PostgreSQL Blog on Microsoft TechCommunity.