Commit433c4c6

authored and

committed

Remember last collation to speed up collation cache.

1 parent2fc8815 commit433c4c6Copy full SHA for 433c4c6

File tree

+13

-0

lines changed

+13

-0

lines changed

Lines changed: 13 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -151,6 +151,13 @@ typedef struct`
`151`	`151`	`staticMemoryContextCollationCacheContext=NULL;`
`152`	`152`	`staticcollation_cache_hash*CollationCache=NULL;`
`153`	`153`
	`154`	`+/*`
	`155`	`+ * The collation cache is often accessed repeatedly for the same collation, so`
	`156`	`+ * remember the last one used.`
	`157`	`+ */`
	`158`	`+staticOidlast_collation_cache_oid=InvalidOid;`
	`159`	`+staticpg_locale_tlast_collation_cache_locale=NULL;`
	`160`	`+`
`154`	`161`	`#if defined(WIN32)&& defined(LC_MESSAGES)`
`155`	`162`	`staticcharIsoLocaleName(constchar);`
`156`	`163`	`#endif`
`@@ -1570,6 +1577,9 @@ pg_newlocale_from_collation(Oid collid)`
`1570`	`1577`	`if (collid==DEFAULT_COLLATION_OID)`
`1571`	`1578`	`return&default_locale;`
`1572`	`1579`
	`1580`	`+if (last_collation_cache_oid==collid)`
	`1581`	`+returnlast_collation_cache_locale;`
	`1582`	`+`
`1573`	`1583`	`cache_entry=lookup_collation_cache(collid);`
`1574`	`1584`
`1575`	`1585`	`if (cache_entry->locale==0)`
`@@ -1695,6 +1705,9 @@ pg_newlocale_from_collation(Oid collid)`
`1695`	`1705`	`cache_entry->locale=resultp;`
`1696`	`1706`	`}`
`1697`	`1707`
	`1708`	`+last_collation_cache_oid=collid;`
	`1709`	`+last_collation_cache_locale=cache_entry->locale;`
	`1710`	`+`
`1698`	`1711`	`returncache_entry->locale;`
`1699`	`1712`	`}`
`1700`	`1713`

Comments

(0)