# Et si on définissait db\_default\_text\_search\_config sur "pg\_catalog.simple"

**URL:** https://meta.discourse.org/t/what-if-set-db-default-text-search-config-pg-catalog-simple/57407
**Category:** Self-hosting
**Created:** [Février 15, 2017, 7:00 UTC](https://meta.discourse.org/t/what-if-set-db-default-text-search-config-pg-catalog-simple/57407 "2017-02-15T07:00:29Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![helperhaps](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/helperhaps/32/59201_2.png) [@helperhaps](https://meta.discourse.org/u/helperhaps)
#### Post date: [Février 15, 2017, 7:00 UTC](https://meta.discourse.org/t/what-if-set-db-default-text-search-config-pg-catalog-simple/57407/1 "2017-02-15T07:00:29Z")

</div>

Recently, I notice that there is a

```yml
params:
  db_default_text_search_config: "pg_catalog.english"

```

in the configuration file (standalone.yml/data.yml). I can guees what it means through its name. The issue is that my locale is CN-zh or my main language is Chinese (That means the same, lol ) and my setting is the default (pg\_catalog.english, never noticed), `and my pg text search work just well`. So what does that do? I can find nothing useful in this site.

So, what if i change this setting to `db_default_text_search_config: "pg_catalog.chinese"` or `db_default_text_search_config: "pg_catalog.simple"`. What will happened?

---

<div class="post-metadata">

### Author: ![meglio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/meglio/32/71444_2.png) [@meglio](https://meta.discourse.org/u/meglio)
#### Post date: [Août 24, 2017, 9:01 UTC](https://meta.discourse.org/t/what-if-set-db-default-text-search-config-pg-catalog-simple/57407/2 "2017-08-24T09:01:56Z")

</div>

I’m also interested in how to use `db_default_text_search_config` correctly in `app.yml`.

---

<div class="post-metadata">

### Author: ![Jacky](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jacky/32/293257_2.png) [@Jacky](https://meta.discourse.org/u/Jacky)
#### Post date: [Décembre 16, 2018, 1:38 UTC](https://meta.discourse.org/t/what-if-set-db-default-text-search-config-pg-catalog-simple/57407/3 "2018-12-16T13:38:20Z")

</div>

I have found some errors when searching Chinese. Some results cannot be shown correctly.

> [@Chinese search doesn't work to some words](https://meta.discourse.org/t/chinese-search-doesnt-work-to-some-words/103815/16):
>
> I paste some missed words here. If you copy them and search them in discourse, you can find that the expected searching results are missed. For this site: (the results should include this page: [https://meta.discourse.org/t/discourse/6780?source\_topic\_id=13287](https://meta.discourse.org/t/discourse/6780?source_topic_id=13287)) 指南发布 For Erick Guan’s site ([https://master1.discoursecn.org/](https://master1.discoursecn.org/)) 重启服务器 (searching results should include: [关于重启服务器需要重建容器以及vps搬家的疑问 - 支持 - Discourse中文论坛](https://meta.discoursecn.org/t/topic/2510))

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [Octobre 31, 2021, 11:58 UTC](https://meta.discourse.org/t/what-if-set-db-default-text-search-config-pg-catalog-simple/57407/4 "2021-10-31T11:58:41Z")

</div>



---

<div class="post-metadata">

### Author: ![Jagster](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jagster/32/192154_2.png) [@Jagster](https://meta.discourse.org/u/Jagster)
#### Post date: [Novembre 14, 2023, 5:42 UTC](https://meta.discourse.org/t/what-if-set-db-default-text-search-config-pg-catalog-simple/57407/5 "2023-11-14T17:42:55Z")

</div>

Je vais relancer ce sujet en douceur, car je cherche une réponse à la même question — ce fut mon premier résultat sur Google 😏

Et maintenant, je retourne à mes résultats de recherche…

**Modification**

Je l’ai lu et j’essaie de comprendre…

> **[12.10. psql Support](https://www.postgresql.org/docs/current/textsearch-psql.html)**
>
> 12.10. psql Support # Information about text search configuration objects can be obtained in psql using a set of commands: \\dF{d,p,t}\[+\] …

J’ai la forte impression que cela ne fait rien d’utile à moins que ispell, thesaurus, etc. ne soient utilisés et que ceux-ci ne fonctionnent principalement qu’en anglais. Il doit y avoir une sorte de schéma, je suppose, mais… Je ne sais pas, mais la grande majorité des résultats (et il n’y en avait pas beaucoup) menaient à des sites chinois ou russes, et j’ai appris il y a longtemps que si les Chinois ou les Russes ont besoin de quelque chose à cause de la langue, cela ne s’applique certainement pas au finnois. Eh bien… rien ne s’applique au finnois (ou à l’estonien, au hongrois, etc.) quand il s’agit de langue de toute façon 🤣

---

<div class="post-metadata">

### Author: ![icaria36](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/icaria36/32/426431_2.png) [@icaria36](https://meta.discourse.org/u/icaria36)
#### Post date: [Avril 21, 2025, 4:03 UTC](https://meta.discourse.org/t/what-if-set-db-default-text-search-config-pg-catalog-simple/57407/6 "2025-04-21T16:03:11Z")

</div>

Même question concernant l’espagnol. Savez-vous si les utilisateurs d’un forum hispanophone constateraient des améliorations dans la recherche ?
