{"Entry":{"collection":"guc","key":"default_text_search_config","name":"default_text_search_config","aliases":[],"metadata":{"baseline":false,"boot_human":"Not specified","boot_val":null,"category":"Client Connection Defaults / Locale and Formatting","category_zh":"","changed_in":[],"changes":[{"documentation_changed":false,"fields":{},"from":"8.2","status":"added","to":"8.3"}],"content_hash":"9a935cae5aea8acf1bd178af1f857584dccef164f6870b7aaaf81d9c6c06d705","context":"","default_changed_in":[],"default_history":[{"from":"9.0","to":"19","value":"pg_catalog.simple"}],"editorial":{"advice":{"olap":"Pin the configuration in reproducible indexing and reporting jobs so locale changes do not silently alter tokenization or ranking.","oltp":"Set default_text_search_config per language domain and application role, or pass the configuration explicitly in durable queries. Verify dictionaries and packages on every replica.","small":"Use pg_catalog.simple or the initdb-selected locale configuration unless language-aware search is required; extra dictionaries add maintenance, not free quality."},"mechanism":["default_text_search_config sets default text search configuration. Text-search functions use it only when the caller omits an explicit configuration; initdb may choose a locale-matching value instead of the built-in simple configuration.","default_text_search_config is a USER-context setting. An authorized role can change it for a session, while ALTER ROLE or ALTER DATABASE can establish a default for future sessions.","It changes representation, parsing, or locale behavior at the client boundary rather than physical storage. Coordinate it with the other locale and formatting settings and with driver-native binary or typed protocols."],"pitfalls":["Changing default_text_search_config in one session and assuming role defaults, database defaults, or other pooled sessions changed with it.","Assuming a presentation setting changes stored values or server-side type semantics.","Changing a role or database default without testing text-parsing clients, exports, and pooled sessions.","Changing default_text_search_config globally without a rollback plan and a client or operational compatibility test."],"references":[{"title":"PostgreSQL 19 Beta 4: default_text_search_config","url":"https://www.postgresql.org/docs/19/runtime-config-client.html#GUC-DEFAULT-TEXT-SEARCH-CONFIG"},{"title":"PostgreSQL 19 release notes","url":"https://www.postgresql.org/docs/19/release-19.html"}],"related":["client_encoding","lc_messages","lc_monetary","lc_numeric","lc_time"],"summary":"default_text_search_config is the PostgreSQL setting that defines default text search configuration."},"enumvals":[],"first_version":"8.3","group":"Client Connection Defaults","group_slug":"client","imported_at":"2026-09-27T17:57:31.103581+08:00","intro_commit":{},"key":"default_text_search_config","last_version":"20","max_val":"","min_val":"","name":"default_text_search_config","position":101,"present_in":["8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"short_desc":"Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying the configuration.","short_desc_zh":"","source_rev":"english-manuals:be2bbd0e35863dc9e331d6a3b209b0e49886c98f6da2a61d0372293310d65075","unit":"","vartype":"string"}},"Definition":{"Collection":"guc","Key":"default_text_search_config","SourceDatabase":"center","Version":"18","SourceTable":"guc","SourceKey":"default_text_search_config","SourceRevision":"english-manuals:be2bbd0e35863dc9e331d6a3b209b0e49886c98f6da2a61d0372293310d65075","Facts":{"boot_val":"pg_catalog.simple","category":"Client Connection Defaults / Locale and Formatting","context":"user","description":"Selects the text search configuration that is used by those variants of the text search functions that do not have an explicit argument specifying the configuration. See Chapter 12 for further information. The built-in default is pg_catalog.simple, but initdb will initialize the configuration file with a setting that corresponds to the chosen lc_ctype locale, if a configuration matching that locale can be identified.","doc":{"anchor":"GUC-DEFAULT-TEXT-SEARCH-CONFIG","file":"runtime-config-client.html","lang":"en","sha256":"6be6cc70f29eca4695dc43b2b2b94c75b7e0eaaa2c00273d7a98488917a7edb7","slug":"18"},"documented":true,"enumvals":null,"extra_desc":null,"lang":"en","max_val":null,"metadata_version":"18","min_val":null,"name":"default_text_search_config","short_desc":"Sets default text search configuration.","source":"pg-settings-source-snapshot","unit":null,"vartype":"string"},"ManualEvidence":{"doc":{"anchor":"GUC-DEFAULT-TEXT-SEARCH-CONFIG","file":"runtime-config-client.html","lang":"en","sha256":"6be6cc70f29eca4695dc43b2b2b94c75b7e0eaaa2c00273d7a98488917a7edb7","slug":"18"}},"MeasuredEvidence":{"metadata_version":"18"}},"Text":{"Collection":"guc","Key":"default_text_search_config","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"default_text_search_config","Summary":"","BodyHTML":"\u003cp\u003e选择被那些没有显式参数指定配置的文本检索函数变体使用的文本检索配置。详见\u003ca href=\"/docs/18/textsearch.html\" rel=\"nofollow\"\u003e第 12 章\u003c/a\u003e。内置默认值是\u003ccode\u003epg_catalog.simple\u003c/code\u003e，但是如果能够标识一个匹配该区域设置的配置，\u003cspan\u003einitdb\u003c/span\u003e将用对应于选中的\u003ccode\u003elc_ctype\u003c/code\u003e区域设置的值初始化配置文件。\u003c/p\u003e","SourceRevision":"2026-09-11@29c86d9","ContentHash":"b0e4c8c5abee19fd7f1c4d3424a7b87cb26ff36e48c25f2cf371e00b551ed175","Payload":{"carried_from":"","carry_reason":"","doc_html":"\u003cp\u003e选择被那些没有显式参数指定配置的文本检索函数变体使用的文本检索配置。详见\u003ca href=\"/docs/18/textsearch.html\" title=\"第 12 章 全文检索\"\u003e第 12 章\u003c/a\u003e。内置默认值是\u003ccode class=\"literal\"\u003epg_catalog.simple\u003c/code\u003e，但是如果能够标识一个匹配该区域设置的配置，\u003cspan class=\"application\"\u003einitdb\u003c/span\u003e将用对应于选中的\u003ccode class=\"varname\"\u003elc_ctype\u003c/code\u003e区域设置的值初始化配置文件。\u003c/p\u003e","doc_same_as":""}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}