.. _postgres_search: ======================== PostgreSQL search engine ======================== .. warning:: | This search backend is deprecated, and has been replaced by ``wagtail.search.backends.database``. See :ref:`wagtailsearch_backends`. This contrib module provides a search engine backend using `PostgreSQL full-text search capabilities `_. .. warning:: | You can only use this module to index data from a PostgreSQL database. **Features**: - It supports all the search features available in Wagtail. - Easy to install and adds no external dependency or service. - Excellent performance for sites with up to 200 000 pages and stays decent for sites up to a million pages. - Faster to reindex than Elasticsearch, if you use PostgreSQL 9.5 or higher. **Drawbacks**: - Partial matching (``SearchField(partial_match=True)``) is not supported - ``SearchField(boost=…)`` is only partially respected as PostgreSQL only supports four different boosts. So if you use five or more distinct values for the boost in your site, slight inaccuracies may occur. - When :ref:`wagtailsearch_specifying_fields`, the index is not used, so it will be slow on huge sites. - Still when :ref:`wagtailsearch_specifying_fields`, you cannot search on a specific method. Installation ============ Add ``'wagtail.contrib.postgres_search',`` anywhere in your ``INSTALLED_APPS``: .. code-block:: python INSTALLED_APPS = [ ... 'wagtail.contrib.postgres_search', ... ] Then configure Wagtail to use it as a search backend. Give it the alias `'default'` if you want it to be the default search backend: .. code-block:: python WAGTAILSEARCH_BACKENDS = { 'default': { 'BACKEND': 'wagtail.contrib.postgres_search.backend', }, } After installing the module, run ``python manage.py migrate`` to create the necessary ``postgres_search_indexentry`` table. You then need to index data inside this backend using the :ref:`update_index` command. You can reuse this command whenever you want. However, it should not be needed after a first usage since the search engine is automatically updated when data is modified. To disable this behaviour, see :ref:`wagtailsearch_backends_auto_update`. Configuration ============= Language / PostgreSQL search configuration ------------------------------------------ Use the additional ``'SEARCH_CONFIG'`` key to define which PostgreSQL search configuration should be used. For example: .. code-block:: python WAGTAILSEARCH_BACKENDS = { 'default': { 'BACKEND': 'wagtail.contrib.postgres_search.backend', 'SEARCH_CONFIG': 'english', } } As you can deduce, a PostgreSQL search configuration is mostly used to define rules for a language, English in this case. A search configuration consists in a compilation of algorithms (parsers & analysers) and language specifications (stop words, stems, dictionaries, synonyms, thesauruses, etc.). A few search configurations are already defined by default in PostgreSQL. You can list them using ``sudo -u postgres psql -c "\dF"`` in a Unix shell or by using this SQL query: ``SELECT cfgname FROM pg_catalog.pg_ts_config``. These already-defined search configurations are decent, but they’re basic compared to commercial search engines. If you want better support for your language, you will have to create your own PostgreSQL search configuration. See the PostgreSQL documentation for `an example `_, `the list of parsers `_, and `a guide to use dictionaries `_. Atomic rebuild -------------- Like the Elasticsearch backend, this backend supports :ref:`wagtailsearch_backends_atomic_rebuild`: .. code-block:: python WAGTAILSEARCH_BACKENDS = { 'default': { 'BACKEND': 'wagtail.contrib.postgres_search.backend', 'ATOMIC_REBUILD': True, } } This is nearly useless with this backend. In Elasticsearch, all data is removed before rebuilding the index. But in this PostgreSQL backend, only objects no longer in the database are removed. Then the index is progressively updated, with no moment where the index is empty. However, if you want to be extra sure that nothing wrong happens while updating the index, you can use atomic rebuild. The index will be rebuilt, but nobody will have access to it until reindexing is complete. If any error occurs during the operation, all changes to the index are reverted as if reindexing was never started.